Some SQL statements supported by SAP 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 with statements that are part of both dialects in a batch or procedure.
You can include statements not supported by Adaptive Server Enterprise with statements that are supported by both servers in a batch or procedure.
You cannot include Transact-SQL–only statements with SAP 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 Reference: Statements and Options for details of individual statements.
Transact-SQL compatibility has improved; incorrect SQL syntax that was previously accepted now fails with an error.