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

  • Garth Wells


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.


Customer Order Select Statement Database Object Default Behavior Loop Operation 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Garth Wells 2001

Authors and Affiliations

  • Garth Wells
    • 1
  1., Inc.USA

Personalised recommendations