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, 1847🔥, 0💬
Popular Posts:
How To Change the Name of a Database User in SQL Server? If you want to change the name of an existi...
Where to find SQL Server Transact-SQL language references? You can find SQL Server Transact-SQL lang...
Where to find tutorials to answer some frequently asked questions on Microsoft SQL Server Transact-S...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...
How Fixed Length Strings Are Truncated and Padded in SQL Server Transact-SQL? When the length of the...