All SQL statements are acceptable in batches (including data definition statements such as CREATE TABLE, ALTER TABLE, and so on), 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