transact-sql-code-snippets.md

title	Transact-SQL Code Snippets | Microsoft Docs
ms.custom
ms.date	03/14/2017
ms.prod	sql-server-2016
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	article
ms.assetid	12834855-535a-4102-8b19-5d18b4080926
caps.latest.revision	5
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Transact-SQL Code Snippets

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.

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 [!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

See Also

Query and Text Editors (SQL Server Management Studio)