Appendix C. T-SQL Statement Syntax

To help you find the syntax you need when you need it, this appendix lists the syntax for the most frequently used T-SQL operations. Each statement starts with a brief description and then displays the appropriate syntax. For added convenience, you’ll also find cross-references to the lessons where specific statements are taught.

When reading statement syntax, remember the following:

• The | symbol is used to indicate one of several options, so NULL|NOT NULL means specify either NULL or NOT NULL.

• Keywords or clauses contained within square parentheses [like this] are optional.

• Not all T-SQL statements are listed, nor is every clause and option listed.

BEGIN TRANSACTION

Get Sams Teach Yourself Microsoft® SQL Server T-SQL in 10 Minutes now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.