Transact-SQL Batch Overview

In Transact-SQL, a batch is a set of SQL statements submitted together and executed as a group, one after the other.

Batches can be stored in command files. The ISQL utility in SQL Anywhere and SAP Sybase IQ and the isql utility in Adaptive Server provide similar capabilities for executing batches interactively.

The control statements used in procedures can also be used in batches. SQL Anywhere and SAP Sybase IQ support the use of control statements in batches and the Transact-SQL-like use of nondelimited groups of statements terminated with a GO statement to signify the end of a batch.

For batches stored in command files, SQL Anywhere and SAP Sybase IQ support the use of parameters in command files. Adaptive Server does not support parameters.