Collections:
Statement Batch in SQL Server Transact-SQL
What is statement batch in SQL Server Transact-SQL?
✍: FYIcenter.com
A statement batch is a group of one or more Transact-SQL statements sent at the same time from an application to SQL Server for execution. SQL Server compiles the statements of a batch into a single executable unit, called an execution plan. The statements in the execution plan are then executed one at a time.
How to define and send a statement batch to SQL Server is depending on the client application you are using. For example:
Remember that "GO" is not a Transact-SQL statement. "GO" is a command of the client tool.
⇒ Compilation Error in a Statement Batch in SQL Server
⇐ Comments in SQL Server Transact-SQL Statements
2017-05-29, 1963🔥, 0💬
Popular Posts:
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...
How To Generate Random Numbers with the RAND() Function in SQL Server Transact-SQL? Random numbers a...
What Happens If the UPDATE Subquery Returns Multiple Rows in MySQL? If a subquery is used in a UPDAT...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...