Writing compatible queries

There are two criteria for writing a query that runs on both SQL Anywhere and Adaptive Server Enterprise databases:

  • The data types, expressions, and search conditions in the query must be compatible.

  • The syntax of the statement itself must be compatible.

This section assumes compatible data types, expressions, and search conditions. The examples assume the quoted_identifier option is set to OFF, which is the default Adaptive Server Enterprise setting, but not the default SQL Anywhere setting.

SQL Anywhere's implementation of the Transact-SQL dialect supports much of the query expression syntax from the Watcom SQL dialect, even though some of these SQL constructions are not supported by Adaptive Server Enterprise. In a Transact-SQL query, SQL Anywhere supports the following SQL constructions:

To summarize, SQL Anywhere's Transact-SQL dialect supports the following:

 Syntax
 Parameters
 Notes
 See also