Topik ini menjelaskan fungsi bawaan Transact-SQL (T-SQL) yang didukung oleh berbagai versi Babelfish.
Tabel berikut menunjukkan fungsi bawaan T-SQL yang didukung oleh berbagai versi Babelfish. Untuk informasi lebih lanjut tentang versi Babelfish, lihat Lihat Versi Babelfish.
Tabel berikut menggambarkan fungsi-fungsi yang didukung.
Tanda centang (✔️) menunjukkan bahwa suatu fungsi didukung.
Tanda silang (❌) menunjukkan bahwa suatu fungsi tidak didukung.
Fungsi bawaan T-SQL | 3.5.0 | 3.3.0 |
APP_NAME | ✔️ | ✔️ |
ATN2 | ✔️ | ✔️ |
CHARINDEX | ✔️ | ✔️ |
CHOOSE | ✔️ | ✔️ |
COL_LENGTH | ✔️ | ❌ |
COL_NAME | ✔️ | ❌ |
COLUMNS_UPDATED | ✔️ | ✔️ |
COLUMNPROPERTY (hanya berlaku untuk properti CharMaxLen dan 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 selalu dikembalikan) | ✔️ | ✔️ |
SMALLDATETIMEFROMPARTS | ✔️ | ✔️ |
SQUARE | ✔️ | ✔️ |
STR | ✔️ | ✔️ |
STRING_AGG | ✔️ | ❌ |
STRING_SPLIT | ✔️ | ✔️ |
SUSER_SID | ✔️ | ✔️ |
SUSER_SNAME | ✔️ | ✔️ |
SWITCHOFFSET | ✔️ | ❌ |
SYSTEM_USER | ✔️ | ✔️ |
TIMEFROMPARTS | ✔️ | ✔️ |
TODATETIMEOFFSET | ✔️ | ❌ |
TO_CHAR | ✔️ | ✔️ |
TRIGGER_NESTLEVEL (tidak diperlukan parameter) | ✔️ | ✔️ |
TRY_CONVERT | ✔️ | ✔️ |
TYPE_ID | ✔️ | ❌ |
TYPE_NAME | ✔️ | ❌ |
UPDATE | ✔️ | ✔️ |