This topic describes Transact-SQL (T-SQL) built-in functions that are supported by different versions of Babelfish.
The following table describes the T-SQL built-in functions supported by different versions of Babelfish. For more information about Babelfish versions, see View the version of Babelfish.
The following table describes the functions that are supported.
Ticks (✔️) indicate that a function is supported.
Crosses (❌) indicate that a function is 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 (applicable only to the CharMaxLen and AllowsNull properties) | ✔️ | ✔️ |
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 always returned) | ✔️ | ✔️ |
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 | ✔️ | ✔️ |