BEGIN ... END Statement Blocks in SQL Server Transact-SQL

Q

How to put statements into a statement block in SQL Server Transact-SQL?

✍: FYIcenter.com

A

You can put statements into a statement block with BEGIN and END key words in Transact-SQL using these syntaxes

BEGIN
   statement_1
   statement_2
   ...
END

Statement blocks are mainly used with logical conditions and control-of-flow keywords to build conditional executions and loops of executions.

Here is an example on how to use BEGIN ... END statement blocks:

BEGIN
   PRINT 'The first half.';
   PRINT 'The second half.';
END

 

Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL

⇒⇒SQL Server Transact-SQL Tutorials

2017-01-11, 321👍, 0💬