DML: SELECT, JOINs, and Control-of-Flow

Abstract

DML (Data Manipulation Language) is the subset of T-SQL that allows you to manipulate data stored in the database objects created with DDL (Data Definition Language) statements. DML is fundamental to working with SQL Server (and understanding the examples presented later in the book) so this chapter covers a lot of important material. The SELECT statement and some of the more useful clauses and operators are covered in detail and the various JOINs are presented and explained through a series of examples. The chapter completes with coverage of the control-of-flow statements available in T-SQL.