United States (English)

Home Library Learn Samples Downloads Support Community Forums

MSDN Library

Servers and Enterprise Development

SQL Server

SQL Server 2012

Product Documentation

Books Online for SQL Server 2012

Database Engine

Transact-SQL Reference (Database Engine)

Control-of-Flow Language (Transact-SQL)

BEGIN...END (Transact-SQL)

BREAK (Transact-SQL)

CONTINUE (Transact-SQL)

ELSE (IF...ELSE) (Transact-SQL)

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

GOTO (Transact-SQL)

IF...ELSE (Transact-SQL)

RETURN (Transact-SQL)

THROW (Transact-SQL)

TRY...CATCH (Transact-SQL)

WAITFOR (Transact-SQL)

WHILE (Transact-SQL)

Minimize

1 out of 3 rated this helpful - Rate this topic

Control-of-Flow Language (Transact-SQL)

SQL Server 2012

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

BEGIN...END	RETURN
BREAK	THROW
CONTINUE	TRY...CATCH
GOTO label	WAITFOR
IF...ELSE	WHILE

Reference

CASE (Transact-SQL)

/*...*/ (Comment) (Transact-SQL)

-- (Comment) (Transact-SQL)

DECLARE @local_variable (Transact-SQL)

EXECUTE (Transact-SQL)

PRINT (Transact-SQL)

RAISERROR (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

© 2013 Microsoft. All rights reserved.