Some SQL statements supported by Sybase IQ are part of one dialect, but not the other. You cannot mix the two dialects within a procedure or batch. This means that:
You can include Transact-SQL-only statements together with statements that are part of both dialects in a batch or procedure.
You can include statements not supported by Adaptive Server Enterprise together with statements that are supported by both servers in a batch or procedure.
You cannot include Transact-SQL-only statements together with Sybase IQ-only statements in a batch or procedure.
SQL statements not separated by semicolons are part of a Transact-SQL procedure or batch. See Chapter 6, “SQL Statements” for details of individual statements.
