ASA SQL Reference
SQL Functions
Alphabetical list of functions
Returns either 'Watcom-SQL' or 'Transact-SQL', indicating the SQL dialect of a statement.
SQLDIALECT ( sql-statement-string )
SQL/92 Vendor extension.
SQL/99 Vendor extension.
Sybase Not supported by Adaptive Server Enterprise.
TRANSACTSQL function [Miscellaneous]
WATCOMSQL function [Miscellaneous]
The following statement returns the string Transact-SQL.
SELECT SQLDIALECT( 'SELECT employeeName = emp_lname FROM employee' ) FROM dummy