What are Control-of-flow language?
The table shows the Transact-SQL control-of-flow keywords.
Keyword Description
BEGIN...END
Defines a statement block.
BREAK
Exits the innermost WHILE loop.
CONTINUE
Restarts a WHILE loop.
GOTO label
Continues processing at the statement following the label as defined by label.
IF...ELSE
Defines conditional, and optionally, alternate execution when a condition is FALSE.
RETURN
Exits unconditionally.
WAITFOR
Sets a delay for statement execution.
WHILE
Repeats statements while a specific condition is TRUE.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment