Any suggestions? Export (0) Print
Expand All

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


THIS TOPIC APPLIES TO:yesSQL Server (starting with 2008) yesAzure SQL Database yesAzure SQL Data Warehouse yesParallel 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

     { sql_statement | statement_block } 
-- Azure SQL Data Warehouse and Parallel Data Warehouse
    sql_statement | statement_block 

{ 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 statements are valid within a BEGIN...END block, certain Transact-SQL statements should not be grouped together within the same batch (statement block).

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
    SELECT FirstName, MiddleName 
    FROM dbo.DimCustomer WHERE LastName = 'Adams';
SET @Iteration += 1

Community Additions

© 2016 Microsoft