Babelfish 的各个版本支持的功能 - Amazon Aurora
Amazon Web Services 文档中描述的 Amazon Web Services 服务或功能可能因区域而异。要查看适用于中国区域的差异,请参阅中国的 Amazon Web Services 服务入门

Babelfish 的各个版本支持的功能

在下表中,您可以找到不同 Babelfish 版本支持的 T-SQL 功能。有关不受支持的功能的列表,请参阅Babelfish 不支持的功能。有关各种 Babelfish 版本的信息,请参阅 Aurora PostgreSQL 版本注释

功能或语法 2.1.0 1.2.1 1.1.0 1.0.0
ALTER ROLE
CREATE ROLE
Create unique indexes
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 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
Built-in functions:
CHARINDEX
CHOOSE
COLUMNS_UPDATED
COLUMNPROPERTY (CharMaxLen, AllowsNull only)
CONCAT_WS
CURSOR_STATUS
DATEFROMPARTS
DATETIMEFROMPARTS
FULLTEXTSERVICEPROPERTY
HAS_DBACCESS
HAS_PERMS_BY_NAME
IS_MEMBER
IS_ROLEMEMBER
IS_SRVROLEMEMBER
ISJSON
JSON_QUERY
JSON_VALUE
OPENJSON
ORIGINAL_LOGIN
PATINDEX
SCHEMA_NAME
SESSION_USER
SQUARE
STRING_SPLIT
SUSER_SID
SUSER_SNAME
TRIGGER_NESTLEVEL (without arguments only)
UPDATE
INFORMATION_SCHEMA catalogs
COLUMNS
DOMAINS
TABLES
TABLE_CONSTRAINTS
System-defined @@ variables:
@@CURSOR_ROWS
@@DATEFIRST
@@DBTS
@@ERROR
@@ERROR=213
@@FETCH_STATUS
@@IDENTITY
@@LOCK_TIMEOUT
@@LOCK_TIMEOUT
@@MAX_CONNECTIONS
@@MAX_PRECISION
@@MICROSOFTVERSION
@@NESTLEVEL
@@PROCID
@@ROWCOUNT
@@SERVERNAME
@@SERVICENAME
@@SPID
@@TRANCOUNT
@@VERSION (note format difference as described in Babelfish 中的 T-SQL 差异.
System stored procedures:
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_fkeys
sp_getapplock
sp_helpdb
sp_helprole
sp_helprolemember
sp_helpuser
sp_oledb_ro_usrname
sp_pkeys
sp_pkeys
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 SERVERPROPERTY function
Babelfish
Collation
CollationID
Edition
EditionID
EngineEdition
IsAdvancedAnalyticsInstalled
IsBigDataCluster
IsFullTextInstalled
IsIntegratedSecurityOnly
IsLocalDB
IsPolyBaseInstalled
IsSingleUser
IsXTPSupported
Japanese_CI_AI
Japanese_CI_AS
Japanese_CS_AS
LicenseType
ProductMajorVersion
ProductMinorVersion
ProductVersion
ServerName
SQL Server views supported by Babelfish
sys.all_columns
sys.all_objects
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