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, 2946🔥, 0💬
Popular Posts:
How to put statements into a statement block in SQL Server Transact-SQL? You can put statements into...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
How To Calculate DATETIME Value Differences Using the DATEDIFF() Function in SQL Server Transact-SQL...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...