Collections:
BEGIN ... END Statement Blocks in SQL Server Transact-SQL
How to put statements into a statement block in SQL Server Transact-SQL?
✍: FYIcenter.com
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
⇒ IF ... ELSE Statement in SQL Server Transact-SQL
⇐ Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
⇑ Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
2017-01-11, 2834🔥, 0💬
Popular Posts:
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
How To Change the Password for Your Own User Account in MySQL? If you want to change the password of...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...