---
title: "Transact-SQL Code Snippets | Microsoft Docs"
ms.custom: ""
ms.date: "03/14/2017"
ms.prod: "sql"
ms.prod_service: "sql-tools"
ms.service: ""
ms.component: "ssms-scripting"
ms.reviewer: ""
ms.suite: "sql"
ms.technology: 
  - "database-engine"
ms.tgt_pltfrm: ""
ms.topic: "article"
ms.assetid: 12834855-535a-4102-8b19-5d18b4080926
caps.latest.revision: 5
author: "MightyPen"
ms.author: "genemi"
manager: "craigg"
ms.workload: "On Demand"
monikerRange: ">= aps-pdw-2016 || = azuresqldb-current || = azure-sqldw-latest || >= sql-server-2016 || = sqlallproducts-allversions"
---
# Transact-SQL Code Snippets
[!INCLUDE[appliesto-ss-asdb-asdw-pdw-md](../../includes/appliesto-ss-asdb-asdw-pdw-md.md)]
  A [!INCLUDE[tsql](../../includes/tsql-md.md)].code snippet is a template containing the basic structure of a [!INCLUDE[tsql](../../includes/tsql-md.md)] statement or block. You can use snippets as a starting point when adding statements in the [!INCLUDE[ssDE](../../includes/ssde-md.md)] 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](../../relational-databases/scripting/insert-transact-sql-snippets.md)|  
|Describes how to enclose a set of [!INCLUDE[tsql](../../includes/tsql-md.md)] statements in a BEGIN, IF, or WHILE block.|[Insert Surround-with Transact-SQL snippets](../../relational-databases/scripting/insert-surround-with-transact-sql-snippets.md)|  
|Describes how to finish building a complete [!INCLUDE[tsql](../../includes/tsql-md.md)] statement or block after inserting a code snippet.|[Complete Transact-SQL Snippets](../../relational-databases/scripting/complete-transact-sql-snippets.md)|  
|Describes how to build your own custom snippets and add them to the set of SQL Server snippets.|[Add Transact-SQL Snippets](../../relational-databases/scripting/add-transact-sql-snippets.md)|  
  
## See Also  
 [Query and Text Editors (SQL Server Management Studio)](../../relational-databases/scripting/query-and-text-editors-sql-server-management-studio.md)