BEGIN/END Statements

Groups a series of SQL statements so that they can be treated as a single statement.

Syntax

BEGIN
    statement
    {statement
    {...}}
END

Syntax Elements

statement
Any supported SQL statement.

Comments

BEGIN and END statements are used to group the statements that form a procedure, and to allow the IF and WHILE statements to control multiple SQL statements.

Examples

CREATE PROC EX1 AS
BEGIN
    -- currency conversion table
    CREATE TABLE CONV (CID VARCHAR(5) PRIMARY KEY, RATE DECIMAL(5,2), CNAME VARCHAR(5))
    -- test data table
    CREATE TABLE TESTDATA (ID SMALLINT PRIMARY KEY, AMT DECIMAL(6,2))
END

Creates a procedure called EX1 that creates two tables. The two CREATE statements are grouped using a BEGIN/END block.

SET @I = 0
SET @V1 = SECOND(CURTIME())+1
WHILE @I<10
BEGIN
    SET @I = @I+1
    SET @V2 = @V1*@I + @V1/@I
    INSERT INTO TESTDATA VALUES(@I,@V2)
END

Groups three statements together for execution in a loop.

See Also

CREATE PROCEDURE statement, IF statement, WHILE statement.