Contents Index Users and groups Creating a Transact-SQL-compatible database

ASA SQL User's Guide
  Transact-SQL Compatibility

Configuring databases for Transact-SQL compatibility


You can eliminate some differences in behavior between Adaptive Server Anywhere and Adaptive Server Enterprise by selecting appropriate options when creating a database or, if you are working on an existing database, when rebuilding the database. You can control other differences by connection level options using the SET TEMPORARY OPTION statement in Adaptive Server Anywhere or the SET statement in Adaptive Server Enterprise.


Creating a Transact-SQL-compatible database
Setting options for Transact-SQL compatibility
Case sensitivity
Ensuring compatible object names
The special Transact-SQL timestamp column and data type
The special IDENTITY column

Contents Index Users and groups Creating a Transact-SQL-compatible database