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, 2465🔥, 0💬
Popular Posts:
How To Use SQL*Plus Built-in Timers in Oracle? If you don't have a stopwatch/timer and want to measu...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To Verify a User name with SQLCMD Tool in SQL Server? The quickest way to verify a user name in ...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...