Step By Step Scripts/C10Code/
Step By Step Scripts/C10Code/01 - Write a SELECT statement.sql
Step By Step Scripts/C10Code/02 - SELECT statement using asterisk to return all columns in a table.sql
Step By Step Scripts/C10Code/03 - Order the result set.sql
Step By Step Scripts/C10Code/04 - Use the equality operator.sql
Step By Step Scripts/C10Code/05 - Use the greater than operator.sql
Step By Step Scripts/C10Code/06 - Use the BETWEEN operator.sql
Step By Step Scripts/C10Code/07 - A more precise BETWEEN.sql
Step By Step Scripts/C10Code/08 - Write a WHERE clause with multiple conditions.sql
Step By Step Scripts/C10Code/09 - Use the IN operator.sql
Step By Step Scripts/C10Code/10 - Use a Wildcard Search.sql
Step By Step Scripts/C10Code/11 - Alias a table and column.sql
Step By Step Scripts/C10Code/12 - Starting Point for Join Query.sql
Step By Step Scripts/C10Code/13 - INNER JOIN example query.sql
Step By Step Scripts/C10Code/14 - Write an INNER JOIN query.sql
Step By Step Scripts/C10Code/15 - Write an OUTER JOIN query.sql
Step By Step Scripts/C10Code/16 - Write a TOP query.sql
Step By Step Scripts/C10Code/17 - Query that returns multiple rows of the same value.sql
Step By Step Scripts/C10Code/18 - Write a query that includes DISTINCT.sql
Step By Step Scripts/C10Code/19 - Write a query that includes UNION.sql
Step By Step Scripts/C11Code/
Step By Step Scripts/C11Code/01 - Write a Pivot query.sql
Step By Step Scripts/C11Code/02 - Prerequisite to writing an UNPIVOT query. Creates table and adds data to table.sql
Step By Step Scripts/C11Code/03 - Write an UnPivot query.sql
Step By Step Scripts/C11Code/04 - Write a paging query.sql
Step By Step Scripts/C11Code/05 - Writing Expression to build full name from firstname and lastname.sql
Step By Step Scripts/C11Code/06 - Write a query with a constant expression.sql
Step By Step Scripts/C11Code/07 - Write a query that uses a variable.sql
Step By Step Scripts/C12Code/
Step By Step Scripts/C12Code/01 - Insert a single row into a table using the INSERT INTO statement.sql
Step By Step Scripts/C12Code/02 - Insert data into an identity column using the INSERT INTO statement.sql
Step By Step Scripts/C12Code/03 - Using a Sequence when Inserting Data.sql
Step By Step Scripts/C12Code/04 - Insert data into a tablue using a SELECT INTO statement.sql
Step By Step Scripts/C12Code/05 - Insert multiple rows into a table using the INTO statement.sql
Step By Step Scripts/C12Code/06 - Update a single row.sql
Step By Step Scripts/C12Code/07 - Delete a single row.sql
Step By Step Scripts/C12Code/08 - Update rows while referencing multiple tables.sql
Step By Step Scripts/C12Code/09 - Delete rows while referencing multiple tables.sql
Step By Step Scripts/C12Code/10 - Use Merge to insert and update data.sql
Step By Step Scripts/C12Code/11 - Output the results of an INSERT statement.sql
Step By Step Scripts/C12Code/12 - Use MERGE to insert and update data.sql
Step By Step Scripts/C12Code/13 - Insert OUTPUT data into a table.sql
Step By Step Scripts/C12Code/14 - Output the results of an UPDATE statement.sql
Step By Step Scripts/C12Code/15 - Use TRUNCATE to delete all rows.sql
Step By Step Scripts/C13Code/
Step By Step Scripts/C13Code/01 - Return date and time values.sql
Step By Step Scripts/C13Code/02 - Return parts of data and time values.sql
Step By Step Scripts/C13Code/03 - Use the DATEFROMPARTS scala function.sql
Step By Step Scripts/C13Code/04 - Perform date calculations and validations.sql
Step By Step Scripts/C13Code/05 - Convert data using CAST.sql
Step By Step Scripts/C13Code/06 - Convert data using CONVERT.sql
Step By Step Scripts/C13Code/07 - Convert dates using the new SQL Server 2012 functions.sql
Step By Step Scripts/C13Code/08 - Use SQL Server string functions.sql
Step By Step Scripts/C13Code/09 - Use the CHOOSE and IIF functions.sql
Step By Step Scripts/C14Code/
Step By Step Scripts/C14Code/01 - Perform a simple aggregation.sql
Step By Step Scripts/C14Code/02 - Perform aggregations with the GROUP BY clause.sql
Step By Step Scripts/C14Code/03 - Windowing data using the ROW_NUMBER function.sql
Step By Step Scripts/C14Code/04 - Create and use a common table expression.sql
Step By Step Scripts/C14Code/05 - Declare and use table variables.sql
Step By Step Scripts/C14Code/06 - Create and use temporary tables.sql
Step By Step Scripts/C14Code/07 - Implement error handling using T-SQL constructs.sql
Step By Step Scripts/C14Code/08 - Limit aggregated rows with a HAVING clause.sql
Step By Step Scripts/C14Code/09 - Use the BEGIN..END block.sql
Step By Step Scripts/C14Code/10 - Use the IF...ELSE block.sql
Step By Step Scripts/C14Code/11 - Use the WHILE loop with BREAK and CONTINUE.sql
Step By Step Scripts/C15Code/
Step By Step Scripts/C15Code/01 - Create an indexed view.sql
Step By Step Scripts/C16Code/
Step By Step Scripts/C16Code/01 - Create a user-defined scalar function.sql
Step By Step Scripts/C16Code/02 - Alter a user-defined scalar function.sql
Step By Step Scripts/C16Code/03 - Drop a user-defined scalar function.sql
Step By Step Scripts/C16Code/04 - Calling Scalar Functions Using the EXECUTE keyword.s