| title | Complete Transact-SQL Snippets | |||
|---|---|---|---|---|
| description | A Transact-SQL snippet is a code template. Learn how to customize its use by inserting content at its replacement points, and by adding syntax elements to the template. | |||
| ms.custom | seo-lt-2019 | |||
| ms.date | 03/14/2017 | |||
| ms.prod | sql | |||
| ms.prod_service | sql-tools | |||
| ms.technology | ssms | |||
| ms.reviewer | ||||
| ms.topic | conceptual | |||
| helpviewer_keywords |
|
|||
| ms.assetid | a8316a58-bb57-485e-845f-84c23360314c | |||
| author | markingmyname | |||
| ms.author | maghan | |||
| 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 ] Once a [!INCLUDEtsql] code snippet has been inserted into a script, you edit the contents of the snippet to build a complete [!INCLUDEtsql] statement.
When you add a [!INCLUDEtsql] snippet to your script, the inserted snippet statement has one or more replacement points, which are highlighted. If you rest your mouse pointer on a replacement point, a tooltip appears with a description of the syntax element you can specify. The [!INCLUDEssDE] Query Editor recognizes the snippet as separate from the surrounding script until you close the source file. The replacement points remain active until you close the source file.
You can also add additional syntax elements to the template code inserted by a snippet. For example, the Create Table snippet template generates two column definitions; you must add additional column definitions to create a table with more than two columns.
-
Use the TAB key to move from one replacement point to the next. Use SHIFT+TAB to move to the previous replacement point.
-
Click CTRL+SPACE to invoke IntelliSense.
-
Select an item from the list, or type a replacement of your choice.
Insert Transact-SQL Snippets
Insert Surround-with Transact-SQL snippets