Contents Index Retrieving IDENTITY column values with @@identity General guidelines for writing portable SQL

ASA SQL User's Guide
  Transact-SQL Compatibility

Writing compatible SQL statements


This section describes general guidelines for writing SQL for use on more than one database-management system, and discusses compatibility issues between Adaptive Server Enterprise and Adaptive Server Anywhere at the SQL statement level.


General guidelines for writing portable SQL
Creating compatible tables
Writing compatible queries
Compatibility of joins

Contents Index Retrieving IDENTITY column values with @@identity General guidelines for writing portable SQL