Supported Built-in Functions
Babelfish provides limited support for system-implemented built-in functions. The following lists detail the functionality implemented for each version of Babelfish (and subsequent releases).
The following built-in functions are supported for versions 2.1.0 and higher:
IS_MEMBER()IS_ROLEMEMBER()HAS_PERMS_BY_NAME()
The following built-in functions are supported for versions 1.2.0 and higher:
COLUMNS_UPDATED()UPDATE()FULLTEXTSERVICEPROPERTY()ISJSON()JSON_QUERY()JSON_VALUE()HAS_DBACCESS()SUSER_SID()SUSER_SNAME()IS_SRVROLEMEMBER()
The following built-in functions are supported for versions 1.1.0 and higher:
CONCAT_WSDATEFROMPARTSDATETIMEFROMPARTSORIGINAL_LOGINSESSION_USERSQUARECHOOSETRIGGER_NESTLEVELCURSOR_STATUS
The following built-in functions are supported for versions 1.0.0 and higher:
ABSACOSASCIIASINATANAPPLOCK_MODEAPPLOCK_TESTCASTCEILINGCHARCHARINDEXCHECKSUMCOALESCECONCATCONVERTCOSCOTCURRENT_TIMESTAMPCURRENT_USERUSERDATALENGTHDATEADDDATEDIFFDATENAMEDATEPARTDAYDB_IDDB_NAMESUSER_IDSUSER_NAMEUSER_IDUSER_NAMEDEFAULT_DOMAINDEGREESEXPERROR_LINEERROR_MESSAGEERROR_NUMBERERROR_PROCEDUREERROR_SEVERITYERROR_STATEFLOORGETDATEGETUTCDATEIIFISDATEISNULLISNUMERICLEFTLENLOGLOG10LOWERLTRIMMONTHNCHARNEWIDNULLIFOBJECT_IDOBJECT_NAMEPATINDEXPIPOWERRADIANSRANDREPLACEREPLICATEREVERSERIGHTROUNDRTRIMSCOPE_IDENTITYIDENT_CURRENTIDENT_INCRIDENT_SEEDSCHEMA_IDSCHEMA_NAMESERVERPROPERTYSIGNSINSPACESQRTSTRING_AGGSTRING_SPLITSTUFFSUBSTRINGSYSDATETIMESYSDATETIMEOFFSETSYSUTCDATETIMETANTRIMTRY_CASTTRY_PARSEUPPERYEARQUOTENAMEXACT_STATESTRING_ESCAPEDATABASEPROPERTYEXCONNECTIONPROPERTYSQL_VARIANT_PROPERTYSESSIONPROPERTYCOLLATIONPROPERTY-
UNICODE TRIGGER_NESTLEVEL()is supported but only without arguments.
Unsupported Built-in Functions
The following Built-in functions are not supported:
ASSEMBLYPROPERTYASYMKEYPROPERTYASYMKEY_IDATN2BINARY_CHECKSUMCASTCERTENCODEDCERTPROPERTYCERT_IDCHOOSECOALESCECOLLATIONPROPERTYCOLUMNPROPERTYCOLUMNS_UPDATEDCOL_LENGTHCOL_NAMECOMPRESSCONTAINSCONTAINSTABLECONTEXT_INFOCONVERTCURRENT_REQUEST_IDCURRENT_TIMEZONECURRENT_TIMEZONE_IDCURRENT_TRANSACTION_IDDATABASEPROPERTYDATABASE_PRINCIPAL_IDDATEDIFF_BIGDATETIME2FROMPARTSDATETIMEOFFSETFROMPARTSDECOMPRESSDIFFERENCEEOMONTHEVENTDATAFILEGROUPPROPERTYFILEGROUP_IDFILEGROUP_NAMEFILEPROPERTYFILEPROPERTYEXFILE_IDFILE_IDEXFILE_NAMEFN_GET_SQLFORMATFORMATMESSAGEGETANSINULLGET_FILESTREAM_TRANSACTION_CONTEXTHASHBYTESHOST_IDHOST_NAMEIDENTITYIIFINDEXKEY_PROPERTYINDEXPROPERTYINDEX_COLIS_OBJECTSIGNEDJSONJSON_MODIFYKEY_GUIDKEY_IDKEY_NAMELOGINPROPERTYMIN_ACTIVE_ROWVERSIONNEWSEQUENTIALIDNULLIFOBJECTPROPERTYOBJECTPROPERTYEXOBJECT_DEFINITIONOBJECT_SCHEMA_NAMEOPENDATASOURCEOPENJSONOPENQUERYOPENROWSETOPENXMLORIGINAL_DB_NAMEPARSEPARSENAMEPARTITIONPERMISSIONSPUBLISHINGSERVERNAMEREVERSEROWCOUNT_BIGSESSION_CONTEXTSIGNBYASYMKEYSIGNBYCERTSMALLDATETIMEFROMPARTSSOUNDEXSTATS_DATESTRSID_BINARYSWITCHOFFSETSYMKEYPROPERTYSYSTEM_USERTERTIARY_WEIGHTSTEXTPTRTEXTVALIDTIMEFROMPARTSTODATETIMEOFFSETTRANSLATETRY_CONVERTTRY_PARSETYPEPROPERTYTYPE_IDTYPE_NAMEUPDATEVERIFYSIGNEDBYASMKEYVERIFYSIGNEDBYCERTVERIGYSIGNEDBYCERTCHANGETABLECHANGE_TRACKING_MIN_VALID_VERSIONCHANGE_TRACKING_CURRENT_VERSIONCHANGE_TRACKING_IS_COLUMN_IN_MASKCHANGE_TRACKING_CONTEXTDEFAULT_DOMAINFILETABLEROOTPATHGETFILENAMESPACEPATHGETPATHLOCATORPATHNAMECONTAINSTABLEFREETEXTFREETEXTTABLESEMANTICKEYPHRASETABLESEMANTICSIMILARITYDETAILSTABLESEMANTICSIMILARITYTABLEFULLTEXTCATALOGPROPERTYFULLTEXTSERVICEPROPERTYENCRYPTBYASYMKEYENCRYPTBYCERTENCRYPTBYKEYENCRYPTBYPASSPHRASEPWDCOMPAREPWDENCRYPTDECRYPTBYASYMKEYDECRYPTBYCERTDECRYPTBYKEYDECRYPTBYKEYAUTOASYMKEYDECRYPTBYKEYAUTOCERTDECRYPTBYPASSPHRASEDECRYPTBYKEYAUTOCERTPREDICT