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.
2017-05-29, 983👍, 0💬
Popular Posts:
Where to find answers to frequently asked questions on SQL Transaction Management in Oracle? Here is...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
Where to find answers to frequently asked questions on Using INSERT, UPDATE and DELETE Statements in...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...