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, 2848🔥, 0💬
Popular Posts:
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL? Sometimes you need ...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How REAL and FLOAT Literal Values Are Rounded in SQL Server Transact-SQL? By definition, FLOAT(n) sh...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...
How To Get a List of All Tables with "sys.tables" View in SQL Server? If you want to see the table y...