Funcionalidade compatível no Babelfish por versão - Amazon Aurora

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