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

• ALTER DATABASE (syntax 3 and 4)
• CONNECT
• CREATE DATABASE
• CREATE DECRYPTED FILE
• CREATE ENCRYPTED FILE
• DISCONNECT
• DROP CONNECTION
• DROP DATABASE
• FORWARD TO
• Interactive SQL statements such as INPUT or OUTPUT
• PREPARE TO COMMIT
• STOP SERVER

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

 See also