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
⇒Conditional Statements and Loops in SQL Server in SQL Server Transact-SQL
2017-01-11, 1423👍, 0💬
Popular Posts:
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
How To Create a Simple Stored Procedure in SQL Server Transact-SQL? If you want to create a simple s...