Encloses a series of Transact\-SQL statements that will execute as a group. BEGIN…END blocks can be nested.
Transact-SQL Syntax Conventions
BEGIN
{ sql_statement | statement_block }
END
{ 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).
Boolean
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;
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)