Sql server® 2012 t-sql fundamentals

 

CHAPTER 1

 

Background to T-SQL Querying and Programming

 

 3

com mon misunderstanding that DML includes only data modification statements, but as I mentioned, 

it also includes SELECT. Another common misunderstanding is that TRUNCATE is a DDL statement, 

but in fact it is a DML statement. DCL deals with permissions and includes statements such as GRANT 

and REVOKE. This book focuses on DML.

T-SQL is based on standard SQL, but it also provides some nonstandard/proprietary extensions. 

When describing a language element for the first time, I’ll typically mention whether it is standard.