SQL dialects and compatibility

This section describes Transact-SQL compatibility and those features of SQL Anywhere that are not commonly found in other SQL implementations.

SQL Anywhere complies with the SQL-92-based United States Federal Information Processing Standard Publication (FIPS PUB) 127. With minor exceptions, SQL Anywhere is compliant with the ISO/ANSI SQL/2008 core specification as documented in the 9 parts of ISO/IEC JTC 1/SC 32 9075-2008. Information about compliance is provided in the reference documentation for each feature of SQL Anywhere.


Testing SQL compliance using the SQL Flagger
SQL Anywhere features that differ from other SQL implementations
Watcom SQL
Transact-SQL compatibility
Adaptive Server Enterprise architectures
Configuring databases for Transact-SQL compatibility
Writing compatible SQL statements
Transact-SQL procedure language overview
Automatic translation of stored procedures
Returning result sets from Transact-SQL procedures
Variables in Transact-SQL procedures
Error handling in Transact-SQL procedures