Statements allowed in procedures, triggers, events, and batches

Most SQL statements are acceptable in batches, with the exception of the following:

You can use COMMIT, ROLLBACK, and SAVEPOINT statements within procedures, triggers, events, and batches with certain restrictions. See Transactions and savepoints in procedures and triggers.

For more information, see the Usage for each SQL statement in SQL statements.


Using SELECT statements in batches