| title | Transact-SQL Code Snippets |
|---|---|
| description | You can use Transact-SQL code snippets to aid your code writing. Look here for a list of snippet tasks with links to articles that describe them. |
| ms.prod | sql |
| ms.technology | ssms |
| ms.topic | conceptual |
| ms.assetid | 12834855-535a-4102-8b19-5d18b4080926 |
| author | markingmyname |
| ms.author | maghan |
| ms.reviewer | |
| ms.custom | seo-lt-2019 |
| ms.date | 03/16/2017 |
| monikerRange | >=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current |
[!INCLUDESQL Server Azure SQL Database Synapse Analytics PDW ]
A [!INCLUDEtsql].code snippet is a template containing the basic structure of a [!INCLUDEtsql] statement or block. You can use snippets as a starting point when adding statements in the [!INCLUDEssDE] 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. | Insert Transact-SQL Snippets |
| Describes how to enclose a set of [!INCLUDEtsql] statements in a BEGIN, IF, or WHILE block. | Insert Surround-with Transact-SQL snippets |
| Describes how to finish building a complete [!INCLUDEtsql] 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 |