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
.