end-begin-end-transact-sql.md

description	END (BEGIN...END) (Transact-SQL)
title	END (BEGIN...END) (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/15/2017
ms.prod	sql
ms.prod_service	database-engine, sql-database, sql-data-warehouse, pdw
ms.reviewer
ms.technology	t-sql
ms.topic	reference
f1_keywords	END END_TSQL
dev_langs	TSQL
helpviewer_keywords	enclosing statements [SQL Server] END keyword BEGIN...END keyword END (BEGIN...END) keyword
ms.assetid	354c4935-1375-4141-8195-61326662f4d2
author	cawrites
ms.author	chadam
monikerRange	>=aps-pdw-2016||=azuresqldb-current||=azure-sqldw-latest||>=sql-server-2016||>=sql-server-linux-2017||=azuresqldb-mi-current

END (BEGIN...END) (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw]

Encloses a series of [!INCLUDEtsql] statements that will execute as a group. BEGIN...END blocks can be nested.

Transact-SQL Syntax Conventions

Syntax

BEGIN   
     { sql_statement | statement_block }   
END   

[!INCLUDEsql-server-tsql-previous-offline-documentation]

Arguments

{ sql_statement| statement_block}
Is any valid [!INCLUDEtsql] statement or statement grouping as defined with a statement block. To define a statement block (batch), use the control-of-flow language keywords BEGIN and END. Although all [!INCLUDEtsql] statements are valid within a BEGIN...END block, certain [!INCLUDEtsql] statements should not be grouped together within the same batch (statement block).

Result Types

Boolean

Examples: [!INCLUDEssSDWfull] and [!INCLUDEssPDW]

In the following example, BEGIN and END define a series of [!INCLUDEDWsql] statements that run together. If the BEGIN...END block are not included, the following example will be in a continuous loop.

-- Uses AdventureWorks  
  
DECLARE @Iteration INTEGER = 0  
WHILE @Iteration <10  
BEGIN  
    SELECT FirstName, MiddleName   
    FROM dbo.DimCustomer WHERE LastName = 'Adams';  
SET @Iteration += 1  
END;  

See Also

ALTER TRIGGER (Transact-SQL)
BEGIN...END (Transact-SQL)
Control-of-Flow Language (Transact-SQL)
CREATE TRIGGER (Transact-SQL)
ELSE (IF...ELSE) (Transact-SQL)
IF...ELSE (Transact-SQL)
WHILE (Transact-SQL)