Output of Query

Table variable vs temp table

Conversion of a plain English problem into T-SQL

An example of how a mathematical problem was converted into T-SQL by evolving a script in iterations.

Power of implicit conversion

Union results

INSERT INTO

Unary & Aliases

Database Collation

Grouping Sets

This script is to check for Queries returning same result set.

Stairway to T-SQL DML

This Stairway will provide you with a basic understanding of how to work with data from SQL Server tables, using SQL Server’s Transact-SQL (T-SQL) dialect. DML is the Data Manipulation Language, and is the aspect of the language dealing with the data. It includes the statements SELECT, INSERT, UPDATE and DELETE. This Stairway will as also provide some history of the SQL language and some general concepts about set theory. Each level will build upon the prior level, so by the time you are finished you will have a good understanding of how to select and modify data from SQL Server.