Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
A Transact-SQL.code snippet is a template containing the basic structure of a Transact-SQL statement or block. You can use snippets as a starting point when adding statements in the Database Engine Query Editor. You can insert the pre-defined snippets supplied with SQL Server, or create your own.
Task Description |
Topic |
|---|---|
Describes how to insert an existing snippet, such as a CREATE TABLE or SELECT snippet. |
|
Describes how to enclose a set of Transact-SQL statements in a BEGIN, IF, or WHILE block. |
|
Describes how to finish building a complete Transact-SQL statement or block after inserting a code snippet. |
|
Describes how to build your own custom snippets and add them to the set of SQL Server snippets. |