|
Home >> FAQs/Tutorials >> SQL Server FAQ
SQL Server FAQ - What Is a Transact-SQL Statement Batch
By: FYIcenter.com
(Continued from previous topic...)
What Is a Transact-SQL Statement Batch?
A batch is a group of one or more Transact-SQL statements sent at the same time
from an application to SQL Server 2005 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 batch is depending on the client application you are using.
For example:
You need to use the GO command in "sqlcmd" tool to end a batch and send it to SQL server.
SQL Server Management Studio also uses GO command to separate batches when multiple statements
are selected for execution.
In ADO, a batch is defined as all the statements entered in the CommandText property of a Command object.
(Continued on next topic...)
- What Is SQL Language?
- What Is Transact-SQL Language?
- What Is a Transact-SQL Statement?
- How To Start and End Transact-SQL Statements?
- How To Enter Comments in Transact-SQL Statements?
- What Is a Transact-SQL Statement Batch?
- What Happens to a Statement Batch If There Is a Compilation Error?
- How To Use GO Command in "sqlcmd"?
- How To Create User Messages with PRINT Statements?
- How Many Categories of Data Types Used by SQL Server?
- What Are Exact Numeric Data Types?
- What Are Approximate Numeric Data Types?
- What Are Date and Time Data Types?
- What Are Character String Data Types?
- What Are Unicode Character String Data Types?
- What Are Binary String Data Types?
- What Are the Differences between CHAR and NCHAR?
- What Are the Differences between CHAR and VARCHAR?
- What Are the Differences between DECIMAL and FLOAT?
|