DML: SELECT, JOINs, and Control-of-Flow
Garth Wells · Apress eBooks · 2001
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. These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.