Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » SQL Anywhere Server - SQL Usage » SQL dialects and compatibility » Compatible SQL statements


Queries that are compatible with Transact-SQL

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:

 See also