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, 3512🔥, 0💬
Popular Posts:
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Assign Debug Privileges to a User in Oracle? In order to run SQL Developer in debug mode, the...
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
What Is ISAM in MySQL? ISAM (Indexed Sequential Access Method) was developed by IBM to store and ret...