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, 2823🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Are Bitwise Operations in SQL Server Transact-SQL? Bitwise operations are binary operations per...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...