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

Syntax

SQLDIALECT( sql-statement-string )

Parameters

Returns

LONG VARCHAR

See also

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

Standards and compatibility

Example

The following statement returns the string Transact-SQL.

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