Control-of-flow keywords help SQL Server determine when and how Transact-SQL statements should execute. With these keywords, you can add logic around and within Transact-SQL statements to control program execution. Control-of-flow keywords add greater flexibility in OLTP application design and help you write clever code. Control-of-flow keywords include
BEGIN…END keywords identify a code block. We typically use them to group Transact-SQL statements. The
BEGIN…END blocks can be nested. We also use
BEGIN…END statements to identify a code block in an
WHILE loop, and
CASE element. The following is the basic syntax ...