Step By Step Scripts\C10Code

....................\.......\01 - Write a SELECT statement.sql

....................\.......\02 - SELECT statement using asterisk to return all columns in a table.sql

....................\.......\03 - Order the result set.sql

....................\.......\04 - Use the equality operator.sql

....................\.......\05 - Use the greater than operator.sql

....................\.......\06 - Use the BETWEEN operator.sql

....................\.......\07 - A more precise BETWEEN.sql

....................\.......\08 - Write a WHERE clause with multiple conditions.sql

....................\.......\09 - Use the IN operator.sql

....................\.......\10 - Use a Wildcard Search.sql

....................\.......\11 - Alias a table and column.sql

....................\.......\12 - Starting Point for Join Query.sql

....................\.......\13 - INNER JOIN example query.sql

....................\.......\14 - Write an INNER JOIN query.sql

....................\.......\15 - Write an OUTER JOIN query.sql

....................\.......\16 - Write a TOP query.sql

....................\.......\17 - Query that returns multiple rows of the same value.sql

....................\.......\18 - Write a query that includes DISTINCT.sql

....................\.......\19 - Write a query that includes UNION.sql

....................\C11Code

....................\.......\01 - Write a Pivot query.sql

....................\.......\02 - Prerequisite to writing an UNPIVOT query. Creates table and adds data to table.sql

....................\.......\03 - Write an UnPivot query.sql

....................\.......\04 - Write a paging query.sql

....................\.......\05 - Writing Expression to build full name from firstname and lastname.sql

....................\.......\06 - Write a query with a constant expression.sql

....................\.......\07 - Write a query that uses a variable.sql

....................\C12Code

....................\.......\01 - Insert a single row into a table using the INSERT INTO statement.sql

....................\.......\02 - Insert data into an identity column using the INSERT INTO statement.sql

....................\.......\03 - Using a Sequence when Inserting Data.sql

....................\.......\04 - Insert data into a tablue using a SELECT INTO statement.sql

....................\.......\05 - Insert multiple rows into a table using the INTO statement.sql

....................\.......\06 - Update a single row.sql

....................\.......\07 - Delete a single row.sql

....................\.......\08 - Update rows while referencing multiple tables.sql

....................\.......\09 - Delete rows while referencing multiple tables.sql

....................\.......\10 - Use Merge to insert and update data.sql

....................\.......\11 - Output the results of an INSERT statement.sql

....................\.......\12 - Use MERGE to insert and update data.sql

....................\.......\13 - Insert OUTPUT data into a table.sql

....................\.......\14 - Output the results of an UPDATE statement.sql

....................\.......\15 - Use TRUNCATE to delete all rows.sql

....................\C13Code

....................\.......\01 - Return date and time values.sql

....................\.......\02 - Return parts of data and time values.sql

....................\.......\03 - Use the DATEFROMPARTS scala function.sql

....................\.......\04 - Perform date calculations and validations.sql

....................\.......\05 - Convert data using CAST.sql

....................\.......\06 - Convert data using CONVERT.sql

....................\.......\07 - Convert dates using the new SQL Server 2012 functions.sql

....................\.......\08 - Use SQL Server string functions.sql

....................\.......\09 - Use the CHOOSE and IIF functions.sql

....................\C14Code

....................\.......\01 - Perform a simple aggregation.sql

....................\.......\02 - Perform aggregations with the GROUP BY clause.sql

....................\.......\03 - Windowing data using the ROW_NUMBER function.sql

.