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, 1509👍, 0💬
Popular Posts:
How To Verify Your PHP Installation in MySQL? PHP provides two execution interfaces: Command Line In...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...
How To List All Stored Procedures in the Current Database in SQL Server Transact-SQL? If you want to...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How to continue to the next iteration of a WHILE loop in SQL Server Transact-SQL? How to use CONTINU...