Control-of-Flow Language (Transact-SQL)

The Transact-SQL control-of-flow language keywords are:

BEGIN...END

RETURN

BREAK

TRY...CATCH

CONTINUE

WAITFOR

GOTO label

WHILE

IF...ELSE

 

See Also

Reference

CASE (Transact-SQL)
/*...*/ (Comment) (Transact-SQL)
-- (Comment) (Transact-SQL)
DECLARE @local_variable (Transact-SQL)
EXECUTE (Transact-SQL)
PRINT (Transact-SQL)
RAISERROR (Transact-SQL)

Other Resources

Batches
Control-of-Flow
Elements of Transact-SQL
Handling Database Engine Errors

Help and Information

Getting SQL Server 2005 Assistance