本文介紹不同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 | ✔️ | ✔️ |