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...)

    1. What Is SQL Language?
    2. What Is Transact-SQL Language?
    3. What Is a Transact-SQL Statement?
    4. How To Start and End Transact-SQL Statements?
    5. How To Enter Comments in Transact-SQL Statements?
    6. What Is a Transact-SQL Statement Batch?
    7. What Happens to a Statement Batch If There Is a Compilation Error?
    8. How To Use GO Command in "sqlcmd"?
    9. How To Create User Messages with PRINT Statements?
    10. How Many Categories of Data Types Used by SQL Server?
    11. What Are Exact Numeric Data Types?
    12. What Are Approximate Numeric Data Types?
    13. What Are Date and Time Data Types?
    14. What Are Character String Data Types?
    15. What Are Unicode Character String Data Types?
    16. What Are Binary String Data Types?
    17. What Are the Differences between CHAR and NCHAR?
    18. What Are the Differences between CHAR and VARCHAR?
    19. What Are the Differences between DECIMAL and FLOAT?

    Related Articles:

    More...


    Other Tutorials/FAQs:

    More...


    Related Resources:

    More...


    Selected Jobs:

    More...