Funcionalidade compatível no Babelfish por versão
Na tabela a seguir, você pode encontrar a funcionalidade T-SQL compatível com diferentes versões do Babelfish. Para ver uma lista de funcionalidades incompatíveis, consulte Funcionalidade não compatível com o Babelfish. Para obter informações sobre várias versões do Babelfish, consulte as Notas de lançamento do Aurora PostgreSQL.
Funcionalidade ou sintaxe | 2.3.0 | 2.2.0 | 2.1.0 | 1.2.1 | 1.1.0 | 1.0.0 | |
---|---|---|---|---|---|---|---|
ALTER ROLE | ✓ | ✓ | ✓ | – | – | – | |
CREATE ROLE | ✓ | ✓ | ✓ | – | – | – | |
Create unique indexes | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
Cross–database procedure execution | ✓ | ✓ | – | – | – | – | |
Cross–database references SELECT,SELECT..INTO, INSERT, UPDATE, DELETE | ✓ | ✓ | ✓ | – | – | – | |
Cursor-typed parameters for input parameters only (not output) | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
Data migration using the bcp client utility | ✓ | ✓ | ✓ | – | – | – | |
Datatypes TIMESTAMP, ROWVERSION (for usage information, see Features with limited implementation | ✓ | ✓ | ✓ | ✓ | – | – | |
DROP DATABASE | ✓ | – | – | – | – | – | |
DROP IF EXISTS (for SCHEMA, DATABASE, and USER objects) | ✓ | ✓ | ✓ | ✓ | – | – | |
DROP ROLE | ✓ | ✓ | ✓ | – | – | – | |
GRANT | ✓ | ✓ | ✓ | ✓ | – | – | |
Identifiers with leading dot character | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
INSTEAD OF triggers on tables (tables only, not views) | ✓ | ✓ | ✓ | ✓ | – | – | |
REVOKE | ✓ | ✓ | ✓ | ✓ | – | – | |
SET BABELFISH_SHOWPLAN_ALL ON (and OFF) | ✓ | ✓ | ✓ | – | – | – | |
SET BABELFISH_STATISTICS PROFILE ON (OFF) | ✓ | ✓ | ✓ | – | – | – | |
SET LOCK_TIMEOUT | ✓ | ✓ | ✓ | ✓ | – | – | |
SSMS: Connecting with the object explorer connection dialog | ✓ | ✓ | ✓ | – | – | – | |
SSMS: Data migration with the Import/Export Wizard | ✓ | ✓ | ✓ | – | – | – | |
SSMS: Partial support for the object explorer | ✓ | ✓ | ✓ | – | – | – | |
Triggers with multiple DML actions can reference transition tables | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
T-SQL hints (join methods, index usage, MAXDOP) | ✓ | – | – | – | – | – | |
Zero-downtime patching (ZDP) | ✓ | – | – | – | – | – | |
Built-in functions: | |||||||
CHARINDEX | ✓ | ✓ | ✓ | – | – | – | |
CHOOSE | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
COLUMNS_UPDATED | ✓ | ✓ | ✓ | ✓ | – | – | |
COLUMNPROPERTY (CharMaxLen, AllowsNull only) | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
CONCAT_WS | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
CURSOR_STATUS | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
DATEADD | ✓ | – | – | – | – | – | |
DATEDIFF | ✓ | – | – | – | – | – | |
DATEFROMPARTS | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
DATENAME | ✓ | – | – | – | – | – | |
DATEPART | ✓ | – | – | – | – | – | |
DATETIMEFROMPARTS | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
DATETIMEOFFSETFROMPARTS | ✓ | – | – | – | – | – | |
FOR JSON | ✓ | – | – | – | – | – | |
FULLTEXTSERVICEPROPERTY | ✓ | ✓ | ✓ | ✓ | – | – | |
HAS_DBACCESS | ✓ | ✓ | ✓ | ✓ | – | – | |
HAS_PERMS_BY_NAME | ✓ | ✓ | ✓ | – | – | – | |
HOST_NAME | ✓ | ✓ | – | – | – | – | |
IS_MEMBER | ✓ | ✓ | ✓ | – | – | – | |
IS_ROLEMEMBER | ✓ | ✓ | ✓ | – | – | – | |
IS_SRVROLEMEMBER | ✓ | ✓ | ✓ | ✓ | – | – | |
ISJSON | ✓ | ✓ | ✓ | ✓ | – | – | |
JSON_MODIFY | ✓ | – | – | – | – | – | |
JSON_QUERY | ✓ | ✓ | ✓ | ✓ | – | – | |
JSON_VALUE | ✓ | ✓ | ✓ | ✓ | – | – | |
OPENJSON | ✓ | ✓ | ✓ | – | – | – | |
ORIGINAL_LOGIN | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
PATINDEX | ✓ | ✓ | ✓ | – | – | – | |
SCHEMA_NAME | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
SESSION_USER | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
SID_BINARY (returns NULL always) | ✓ | ✓ | – | – | – | – | |
SQUARE | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
STRING_SPLIT | ✓ | ✓ | ✓ | – | – | – | |
SUSER_SID | ✓ | ✓ | ✓ | ✓ | – | – | |
SUSER_SNAME | ✓ | ✓ | ✓ | ✓ | – | – | |
SYSTEM_USER | ✓ | ✓ | – | – | – | – | |
TO_CHAR | ✓ | – | – | – | – | – | |
TRIGGER_NESTLEVEL (without arguments only) | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
TRY_CONVERT | ✓ | – | – | – | – | – | |
UPDATE | ✓ | ✓ | ✓ | ✓ | – | – | |
INFORMATION_SCHEMA catalogs | |||||||
CHECK_CONSTRAINTS | ✓ | ✓ | – | – | – | – | |
COLUMN_DOMAIN_USAGE | ✓ | ✓ | – | – | – | – | |
COLUMNS | ✓ | ✓ | ✓ | ✓ | – | – | |
CONSTRAINT_COLUMN_USAGE | ✓ | ✓ | ✓ | – | – | – | – |
DOMAINS | ✓ | ✓ | ✓ | ✓ | – | – | |
ROUTINES | ✓ | ✓ | – | – | – | – | |
TABLES | ✓ | ✓ | ✓ | ✓ | – | – | |
TABLE_CONSTRAINTS | ✓ | ✓ | ✓ | ✓ | – | – | |
VIEWS | ✓ | ✓ | ✓ | – | – | – | – |
System-defined @@ variables: | |||||||
@@CURSOR_ROWS | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
@@DATEFIRST | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@DBTS | ✓ | ✓ | ✓ | ✓ | – | – | |
@@ERROR | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@ERROR=213 | ✓ | ✓ | ✓ | – | – | – | |
@@FETCH_STATUS | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@IDENTITY | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@LANGUAGE | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@LOCK_TIMEOUT | ✓ | ✓ | ✓ | ✓ | – | – | |
@@MAX_CONNECTIONS | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
@@MAX_PRECISION | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@MICROSOFTVERSION | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
@@NESTLEVEL | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
@@PROCID | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
@@ROWCOUNT | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@SERVERNAME | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@SERVICENAME | ✓ | ✓ | ✓ | ✓ | – | – | |
@@SPID | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@TRANCOUNT | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
@@VERSION (note format difference as described in Diferenças do T-SQL no Babelfish. | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
System stored procedures: | |||||||
sp_addrole | ✓ | – | – | – | – | – | |
sp_addrolemember | ✓ | – | – | – | – | – | |
sp_column_privileges | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_columns | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_columns_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_columns_managed | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursor | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursor_list | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursorclose | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursorexecute | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursorfetch | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursoropen | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursoroption | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursorprepare | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursorprepexec | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_cursorunprepare | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_databases | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_datatype_info | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_datatype_info_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_describe_cursor | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_describe_first_result_set | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_describe_undeclared_parameters | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_droprole | ✓ | – | – | – | – | – | |
sp_droprolemember | ✓ | – | – | – | – | – | |
sp_fkeys | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_getapplock | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sp_helpdb | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sp_helpdbfixedrole | ✓ | – | – | – | – | – | |
sp_helprole | ✓ | ✓ | ✓ | – | – | – | |
sp_helprolemember | ✓ | ✓ | ✓ | – | – | – | |
sp_helpsrvrolemember | ✓ | ✓ | – | – | – | – | |
sp_helpuser | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_oledb_ro_usrname | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_pkeys | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_prefix | ✓ | ✓ | – | – | – | – | |
sp_prepare | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_releaseapplock | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sp_special_columns | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_sproc_columns | ✓ | ✓ | ✓ | – | – | – | |
sp_sproc_columns_100 | ✓ | ✓ | ✓ | – | – | – | |
sp_statistics | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_statistics_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_stored_procedures | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_table_privileges | ✓ | ✓ | ✓ | ✓ | – | – | |
sp_tablecollations_100 | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_tables | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
sp_unprepare | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
xp_qv | ✓ | ✓ | ✓ | ✓ | – | – | |
Properties supported on the CONNECTIONPROPERTY system function | |||||||
auth_scheme | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
client_net_address | ✓ | ✓ | ✓ | ✓ | – | – | |
local_net_address | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
local_tcp_port | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
net_transport | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
protocol_type | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
physical_net_transport | ✓ | ✓ | ✓ | ✓ | – | – | |
Properties supported on the OBJECTPROPERTY system function | |||||||
IsInlineFunction | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
IsScalarFunction | ✓ | ✓ | ✓ | ✓ | – | – | |
IsTableFunction | ✓ | ✓ | ✓ | ✓ | ✓ | – | |
Properties supported on the SERVERPROPERTY function | |||||||
Babelfish | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
Collation | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
CollationID | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
Edition | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
EditionID | ✓ | ✓ | ✓ | ✓ | – | – | |
EngineEdition | ✓ | ✓ | ✓ | ✓ | – | – | |
InstanceName | ✓ | ✓ | – | – | – | – | |
IsAdvancedAnalyticsInstalled | ✓ | ✓ | ✓ | ✓ | – | – | |
IsBigDataCluster | ✓ | ✓ | ✓ | ✓ | – | – | |
IsFullTextInstalled | ✓ | ✓ | ✓ | ✓ | – | – | |
IsIntegratedSecurityOnly | ✓ | ✓ | ✓ | ✓ | – | – | |
IsLocalDB | ✓ | ✓ | ✓ | ✓ | – | – | |
IsPolyBaseInstalled | ✓ | ✓ | ✓ | ✓ | – | – | |
IsSingleUser | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
IsXTPSupported | ✓ | ✓ | ✓ | ✓ | – | – | |
Japanese_CI_AI | ✓ | ✓ | ✓ | – | – | – | |
Japanese_CI_AS | ✓ | ✓ | ✓ | – | – | – | |
Japanese_CS_AS | ✓ | ✓ | ✓ | – | – | – | |
LicenseType | ✓ | ✓ | ✓ | ✓ | – | – | |
MachineName | ✓ | ✓ | – | – | – | – | |
ProductMajorVersion | ✓ | ✓ | ✓ | ✓ | – | – | |
ProductMinorVersion | ✓ | ✓ | ✓ | ✓ | – | – | |
ProductVersion | ✓ | ✓ | ✓ | ✓ | – | – | |
ServerName | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
SQL Server views supported by Babelfish | |||||||
sys.all_columns | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.all_objects | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.all_parameters | ✓ | – | – | – | – | – | |
sys.all_sql_modules | ✓ | ✓ | ✓ | – | – | – | |
sys.all_views | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.columns | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.configurations | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.data_spaces | ✓ | ✓ | ✓ | – | – | – | |
sys.database_files | ✓ | ✓ | ✓ | – | – | – | |
sys.database_mirroring | ✓ | ✓ | ✓ | – | – | – | |
sys.database_principals | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.database_role_members | ✓ | ✓ | ✓ | – | – | – | |
sys.databases | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.dm_exec_connections | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.dm_exec_sessions | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.dm_hadr_database_replica_states | ✓ | ✓ | ✓ | – | – | – | |
sys.dm_os_host_info | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.endpoints | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.indexes | ✓ | ✓ | ✓ | – | – | – | |
sys.schemas | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.server_principals | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.sql_modules | ✓ | ✓ | ✓ | – | – | – | |
sys.sysconfigures | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.syscurconfigs | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.sysprocesses | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.table_types | ✓ | ✓ | ✓ | ✓ | – | – | |
sys.tables | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ | |
sys.xml_schema_collections | ✓ | ✓ | ✓ | – | – | – | |
syslanguages | ✓ | ✓ | ✓ | – | – | – | |
sysobjects.crdate | ✓ | – | – | – | – | – |