Contents Index Writing compatible SQL statements Creating compatible tables

ASA SQL User's Guide
  Transact-SQL Compatibility
    Writing compatible SQL statements

General guidelines for writing portable SQL


When writing SQL for use on more than one database-management system, make your SQL statements as explicit as possible. Even if more than one server supports a given SQL statement, it may be a mistake to assume that default behavior is the same on each system. General guidelines applicable to writing compatible SQL include:


Contents Index Writing compatible SQL statements Creating compatible tables