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

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

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

Result Types

Boolean

See Also

Reference

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)

Other Resources

Batches

Help and Information

Getting SQL Server 2005 Assistance