将 NULL 常量转换为 NUMERIC 或字符串类型(如 CHAR、VARCHAR、LONG VARCHAR、BINARY、VARBINARY 和 LONG BINARY)时,大小将设置为 0。例如:
SELECT CAST( NULL AS CHAR )
返回 CHAR(0)
SELECT CAST( NULL AS NUMERIC )
返回 NUMERIC(1,0)
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |