本文介绍不同Babelfish版本支持的T-SQL内置函数。
不同Babelfish版本支持的T-SQL内置函数如下表所示。查看Babelfish版本请参见查看Babelfish版本详情。
为便于浏览和内容表达，本文的表格约定使用下述注释：
✔️表示支持。
❌表示不支持。
T-SQL内置函数 | 3.5.0 | 3.3.0 |
APP_NAME | ✔️ | ✔️ |
ATN2 | ✔️ | ✔️ |
CHARINDEX | ✔️ | ✔️ |
CHOOSE | ✔️ | ✔️ |
COL_LENGTH | ✔️ | ❌ |
COL_NAME | ✔️ | ❌ |
COLUMNS_UPDATED | ✔️ | ✔️ |
COLUMNPROPERTY （仅适用于CharMaxLen和AllowsNull属性） | ✔️ | ✔️ |
CONCAT_WS | ✔️ | ✔️ |
CONTEXT_INFO | ✔️ | ✔️ |
CURSOR_STATUS | ✔️ | ✔️ |
DATABASE_PRINCIPAL_ID | ✔️ | ✔️ |
DATEADD | ✔️ | ✔️ |
DATEDIFF | ✔️ | ✔️ |
DATEDIFF_BIG | ✔️ | ✔️ |
DATEFROMPARTS | ✔️ | ✔️ |
DATENAME | ✔️ | ✔️ |
DATEPART | ✔️ | ✔️ |
DATETIMEFROMPARTS | ✔️ | ✔️ |
DATETIME2FROMPARTS | ✔️ | ✔️ |
DATETIMEOFFSETFROMPARTS | ✔️ | ✔️ |
DATETRUNC | ✔️ | ❌ |
DATE_BUCKET | ✔️ | ❌ |
EOMONTH | ✔️ | ❌ |
EXECUTE AS CALLER | ✔️ | ✔️ |
fn_listextendedproperty | ✔️ | ✔️ |
FOR JSON | ✔️ | ✔️ |
FULLTEXTSERVICEPROPERTY | ✔️ | ✔️ |
HAS_DBACCESS | ✔️ | ✔️ |
HAS_PERMS_BY_NAME | ✔️ | ✔️ |
HOST_NAME | ✔️ | ✔️ |
HOST_ID | ✔️ | ✔️ |
IDENTITY | ✔️ | ❌ |
IS_MEMBER | ✔️ | ✔️ |
IS_ROLEMEMBER | ✔️ | ✔️ |
IS_SRVROLEMEMBER | ✔️ | ✔️ |
ISJSON | ✔️ | ✔️ |
JSON_MODIFY | ✔️ | ✔️ |
JSON_QUERY | ✔️ | ✔️ |
JSON_VALUE | ✔️ | ✔️ |
NEXT VALUE FOR | ✔️ | ✔️ |
OBJECT_DEFINITION | ✔️ | ✔️ |
OBJECT_SCHEMA_NAME | ✔️ | ✔️ |
OPENJSON | ✔️ | ✔️ |
OPENQUERY | ✔️ | ✔️ |
ORIGINAL_LOGIN | ✔️ | ✔️ |
PARSENAME | ✔️ | ✔️ |
PATINDEX | ✔️ | ✔️ |
ROWCOUNT_BIG | ✔️ | ✔️ |
SCHEMA_NAME | ✔️ | ✔️ |
SESSION_CONTEXT | ✔️ | ✔️ |
SESSION_USER | ✔️ | ✔️ |
SID_BINARY （始终返回NULL） | ✔️ | ✔️ |
SMALLDATETIMEFROMPARTS | ✔️ | ✔️ |
SQUARE | ✔️ | ✔️ |
STR | ✔️ | ✔️ |
STRING_AGG | ✔️ | ❌ |
STRING_SPLIT | ✔️ | ✔️ |
SUSER_SID | ✔️ | ✔️ |
SUSER_SNAME | ✔️ | ✔️ |
SWITCHOFFSET | ✔️ | ❌ |
SYSTEM_USER | ✔️ | ✔️ |
TIMEFROMPARTS | ✔️ | ✔️ |
TODATETIMEOFFSET | ✔️ | ❌ |
TO_CHAR | ✔️ | ✔️ |
TRIGGER_NESTLEVEL（仅适用于不带参数的情况） | ✔️ | ✔️ |
TRY_CONVERT | ✔️ | ✔️ |
TYPE_ID | ✔️ | ❌ |
TYPE_NAME | ✔️ | ❌ |
UPDATE | ✔️ | ✔️ |