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:
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|