Transact-SQL Code Snippets
Applies to: 
SQL Server
Azure SQL Database
Azure SQL Managed Instance
Azure Synapse Analytics
Analytics Platform System (PDW)
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.
Transact-SQL Code Snippet Tasks
| Task Description | Topic |
|---|---|
| Describes how to insert an existing snippet, such as a CREATE TABLE or SELECT snippet. | Insert Transact-SQL Snippets |
| Describes how to enclose a set of Transact-SQL statements in a BEGIN, IF, or WHILE block. | Insert Surround-with Transact-SQL snippets |
| Describes how to finish building a complete Transact-SQL statement or block after inserting a code snippet. | Complete Transact-SQL Snippets |
| Describes how to build your own custom snippets and add them to the set of SQL Server snippets. | Add Transact-SQL Snippets |
See Also
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for