SQL Server T-SQL Recipes, Fourth Edition

CHAPTER 1

Getting Started with SELECT

by Jonathan Gennick

Transact-SQL is a proprietary implementation of the SQL language. It is often referred to simply as T-SQL, and you’ll see us calling it by that shorter name throughout this book. The T-SQL language extends SQL by adding procedural syntax that is useful in programming both application and business logic to run inside the database server. There’s much to learn, and it all begins right here with SELECT.

 Tip  You can find and download various editions of the Adventure Works example database ...