Contents Index Transact-SQL trigger overview Automatic translation of stored procedures

ASA SQL User's Guide
  Transact-SQL Compatibility
    Transact-SQL procedure language overview

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 Interactive SQL utility in Adaptive Server Anywhere and the isql utility in Adaptive Server Enterprise provide similar capabilities for executing batches interactively.

The control statements used in procedures can also be used in batches. Adaptive Server Anywhere supports the use of control statements in batches and the Transact-SQL-like use of non-delimited groups of statements terminated with a GO statement to signify the end of a batch.

For batches stored in command files, Adaptive Server Anywhere supports the use of parameters in command files. Adaptive Server Enterprise does not support parameters.

For information on parameters, see PARAMETERS statement [Interactive SQL].


Contents Index Transact-SQL trigger overview Automatic translation of stored procedures