BEGIN
statement-list
END

statement-list : 
sql-statement
| variable-declaration
| cursor-declaration
| temporary-table-declaration

variable-declaration : See DECLARE statement.

cursor-declaration : See DECLARE CURSOR statement [ESQL] [SP].

temporary-table-declaration : See DECLARE LOCAL TEMPORARY TABLE statement.

A BEGIN statement allows one or more SQL statements to be grouped together and treated as a unit, and starts with the keyword BEGIN and ends with the keyword END.

Error handling is different for Transact-SQL compound statements.

None.

None.

• Error handling in Transact-SQL procedures
• Stored procedures, triggers, batches, and user defined functions
• BEGIN statement
• CONTINUE statement
• GOTO statement [T-SQL]
• RAISERROR statement
• Transact-SQL-compatible databases

The example below declares the following variables:

• v1 as an INT with the initial setting of 5.
• v2 and v3 as CHAR(10), both with an initial value of abc.

BEGIN
   DECLARE v1 INT = 5
   DECLARE v2, v3 CHAR(10) = 'abc'
			// ...
END