接受 Transact-SQL 语句并以 Watcom-SQL 方言重写该语句。将现有 Adaptive Server Enterprise 存储过程转换成 Watcom SQL 语法时,此函数会有用处。
WATCOMSQL( sql-statement-string )
sql-statement-string 函数用来确定其方言的 SQL 语句。
LONG VARCHAR
SQL/2003 服务商扩充。
以下语句返回字符串 'SELECT empl_name AS EmployeeName FROM Employees'
。
SELECT WATCOMSQL( 'SELECT EmployeeName=empl_name FROM Employees' ) FROM dummy; |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |