SQL Insider. Drilling Down on Queries. Now that you understand the basic structure of a SQL application, let's dissect the basis of information retrieval: the query.

I added a table to the Chinook database that contained a column of each of the SQL Server data types to ensure that each would be generated correctly. Listing 3 shows the T-SQL script to create the ...