The following table lists Transact-SQL (T-SQL) built-in functions and their support status across Babelfish versions. All listed functions are supported in version 3.5.0.
To check the Babelfish version running on your instance, see View the version of Babelfish.
Note
✔️ = supported. ❌ = not supported.
| T-SQL built-in function | 3.5.0 | 3.3.0 |
|---|---|---|
| APP_NAME | ✔️ | ✔️ |
| ATN2 | ✔️ | ✔️ |
| CHARINDEX | ✔️ | ✔️ |
| CHOOSE | ✔️ | ✔️ |
| COL_LENGTH | ✔️ | ❌ |
| COL_NAME | ✔️ | ❌ |
| COLUMNS_UPDATED | ✔️ | ✔️ |
| COLUMNPROPERTY (CharMaxLen and AllowsNull only) | ✔️ | ✔️ |
| 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 (always returns NULL) | ✔️ | ✔️ |
| SMALLDATETIMEFROMPARTS | ✔️ | ✔️ |
| SQUARE | ✔️ | ✔️ |
| STR | ✔️ | ✔️ |
| STRING_AGG | ✔️ | ❌ |
| STRING_SPLIT | ✔️ | ✔️ |
| SUSER_SID | ✔️ | ✔️ |
| SUSER_SNAME | ✔️ | ✔️ |
| SWITCHOFFSET | ✔️ | ❌ |
| SYSTEM_USER | ✔️ | ✔️ |
| TIMEFROMPARTS | ✔️ | ✔️ |
| TODATETIMEOFFSET | ✔️ | ❌ |
| TO_CHAR | ✔️ | ✔️ |
| TRIGGER_NESTLEVEL (no parameters required) | ✔️ | ✔️ |
| TRY_CONVERT | ✔️ | ✔️ |
| TYPE_ID | ✔️ | ❌ |
| TYPE_NAME | ✔️ | ❌ |
| UPDATE | ✔️ | ✔️ |