END (BEGIN…END) (Transact-SQL)

**APPLIES TO:** ![yes](media/yes.png)SQL Server (starting with 2008) ![yes](media/yes.png)Azure SQL Database ![yes](media/yes.png)Azure SQL Data Warehouse ![yes](media/yes.png)Parallel Data Warehouse

Encloses a series of Transact\-SQL statements that will execute as a group. BEGIN…END blocks can be nested.

Topic link icon Transact-SQL Syntax Conventions

Syntax

BEGIN   
     { sql_statement | statement_block }   
END   

Arguments

{ sql_statement| statement_block}
Is any valid Transact\-SQL 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 Transact\-SQL Transact\-SQL statements are valid within a BEGIN…END block, certain Transact\-SQL Transact\-SQL Transact\-SQL 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 SQL 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)