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

SQLDIALECT function [Miscellaneous]

Returns either Watcom-SQL or Transact-SQL, to indicate the SQL dialect of a statement.

SQLDIALECT( sql-statement-string )

sql-statement-string    The SQL statement that the function uses to determine its dialect.

• TRANSACTSQL function [Miscellaneous]
• WATCOMSQL function [Miscellaneous]

• SQL/2003    Vendor extension.

The following statement returns the string Transact-SQL.

SELECT
   SQLDIALECT( 'SELECT employeeName = Surname FROM Employees' )
FROM dummy;