What Is a Transact-SQL Statement Batch in MS SQL Server?
Submitted by: AdministratorA 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.
Submitted by: Administrator
# 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.
Submitted by: Administrator
Read Online MS SQL Server Job Interview Questions And Answers
Top MS SQL Server Questions
☺ | How To Get the Definition of a View Out of the SQL Server? |
☺ | What Happens If Strings Are Casted into Wrong Code Pages in MS SQL Server? |
☺ | PHP MSSQL - How To Display a Past Time in Days, Hours and Minutes? |
☺ | How To Create a View on an Existing Table in MS SQL Server? |
☺ | How To Select All Columns of All Rows from a Table with a SELECT statement in MS SQL Server? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |