VENDAS: 1-800-867-1389

Instruções Transact-SQL sem suporte (Banco de Dados SQL do Azure)

Atualizado: fevereiro de 2014

Este tópico está DESATUALIZADO. Você pode encontrar a versão mais atual em Referência de Transact-SQL do SQL 14.

O Microsoft Banco de dados SQL do Microsoft Azure não oferece suporte a todas as instruções Transact-SQL fornecidas no SQL Server 2008. A tabela a seguir fornece uma lista das instruções Transact-SQL para as quais o Banco de dados SQL do Microsoft Azure não oferece suporte.

 

$PARTITION

fn_syscollector_get_execution_stats

ADD SIGNATURE

fn_trace_geteventinfo

ALTER RESOURCE GOVERNOR

fn_trace_getinfo

ALTER SERVICE MASTER KEY

fn_trace_gettable

ASSEMBLYPROPERTY

fn_virtualfilestats

ASYMKEY_ID

fn_virtualservernodes

ASYMKEYPROPERTY

FREETEXT

BACKUP

FREETEXTTABLE

BACKUP CERTIFICATE

FULLTEXTCATALOGPROPERTY

BACKUP MASTER KEY

FULLTEXTSERVICEPROPERTY

BACKUP SERVICE MASTER KEY

GET CONVERSATION GROUP

BEGIN CONVERSATION TIMER

GET_FILESTREAM_TRANSACTION_CONTEXT

BEGIN DIALOG CONVERSATION

GET_TRANSMISSION_STATUS

BEGIN DISTRIBUTED TRANSACTION

GRANT/REVOKE/DENY ALL

BULK INSERT

GRANT/REVOKE/DENY ALL PRIVILEGES

cdc.fn_cdc_get_all_changes_<capture_instance>

Permissões de assembly GRANT/REVOKE/DENY

cdc.fn_cdc_get_net_changes_<capture_instance>

Permissões de chave assimétrica GRANT/REVOKE/DENY

CERT_ID

Permissões de certificado GRANT/REVOKE/DENY

CERTPROPERTY

Permissões de ponto de extremidade GRANT/REVOKE/DENY

CHANGE_TRACKING_CURRENT_VERSION

Permissões de catálogo de texto completo GRANT/REVOKE/DENY

CHANGE_TRACKING_IS_COLUMN_IN_MASK

Permissões de servidor GRANT/REVOKE/DENY

CHANGE_TRACKING_MIN_VALID_VERSION

Permissões de entidade de segurança do servidor GRANT/REVOKE/DENY

CHANGETABLE

Permissões do Service Broker GRANT/REVOKE/DENY

CHECKPOINT

Permissões de chave simétrica GRANT/REVOKE/DENY

CLOSE MASTER KEY

Permissões de objeto do sistema GRANT/REVOKE/DENY

CLOSE SYMMETRIC KEY

Permissões de coleção de esquemas XML GRANT/REVOKE/DENY

COMPUTE

CONNECTIONPROPERTY

HAS_DBACCESS

CONTAINS

INDEXKEY_PROPERTY

CONTAINSTABLE

IS_OBJECTSIGNED

CREATE/DROP AGGREGATE

KEY_GUID

CREATE/ALTER/DROP APPLICATION ROLE

KEY_ID

CREATE/ALTER/DROP ASSEMBLY

KEY_NAME

CREATE/ALTER/DROP ASYMMETRIC KEY

CREATE/ALTER/DROP BROKER PRIORITY

KILL QUERY NOTIFICATION SUBSCRIPTION

CREATE/ALTER/DROP CERTIFICATE

KILL STATS JOB

CREATE/ALTER/DROP CONTRACT

LOGINPROPERTY

CREATE/ALTER/DROP CREDENTIAL

MOVE CONVERSATION

CREATE/ALTER/DROP CRYPTOGRAPHIC PROVIDER

NEWSEQUENTIALID

CREATE/ALTER/DROP DATABASE AUDIT SPECIFICATION

OBJECT_DEFINITION

CREATE/ALTER/DROP DATABASE ENCRYPTION KEY

OPEN MASTER KEY

CREATE/ALTER/DROP DEFAULT

OPEN SYMMETRIC KEY

CREATE/ALTER/DROP ENDPOINT

OPENDATASOURCE

CREATE/ALTER/DROP EVENT NOTIFICATION

OPENQUERY

CREATE/ALTER/DROP EVENT SESSION

OPENROWSET

CREATE/ALTER/DROP FULLTEXT CATALOG

OPENXML

CREATE/ALTER/DROP FULLTEXT INDEX

ORIGINAL_DB_NAME

CREATE/ALTER/DROP FULLTEXT STOPLIST

ORIGINAL_LOGIN

CREATE/ALTER/DROP MASTER KEY

PathName

CREATE/ALTER/DROP MESSAGE TYPE

PUBLISHINGSERVERNAME

CREATE/ALTER/DROP PARTITION FUNCTION

READTEXT

CREATE/ALTER/DROP PARTITION SCHEME

RECEIVE

CREATE/ALTER/DROP QUEUE

RECONFIGURE

CREATE/ALTER/DROP REMOTE SERVICE BINDING

RESTORE

CREATE/ALTER/DROP RESOURCE POOL

RESTORE FILELISTONLY

CREATE/ALTER/DROP ROUTE

RESTORE HEADERONLY

CREATE/ALTER/DROP SERVER AUDIT

RESTORE LABELONLY

CREATE/ALTER/DROP SERVER AUDIT SPECIFICATION

RESTORE MASTER KEY

CREATE/ALTER/DROP SERVICE

RESTORE REWINDONLY

CREATE/ALTER/DROP SYMMETRIC KEY

RESTORE SERVICE MASTER KEY

CREATE/ALTER/DROP WORKLOAD GROUP

RESTORE VERIFYONLY

CREATE/ALTER/DROP XML SCHEMA COLLECTION

Cláusula SELECT INTO

CREATE/DROP RULE

SEND

CREATE/DROP XML INDEX

SET ANSI_DEFAULTS

DATABASEPROPERTY

SET ANSI_NULLS

DBCC CHECKALLOC

SET CONCAT_NULL_YIELDS_NULL

DBCC CHECKCATALOG

SET ANSI PADDING_OFF

DBCC CHECKCONSTRAINTS

SET CONTEXT_INFO

DBCC CHECKDB

SET DISABLE_DEF_CNST_CHK

DBCC CHECKFILEGROUP

SET OFFSETS

DBCC CHECKIDENT

SET REMOTE_PROC_TRANSACTIONS

DBCC CHECKTABLE

SETUSER

DBCC CLEANTABLE

SHUTDOWN

DBCC DBREINDEX

SIGNBYASYMKEY

DBCC dllname

SIGNBYCERT

DBCC DROPCLEANBUFFERS

snapshots.fn_trace_getdata

DBCC FREEPROCCACHE

SYMKEYPROPERTY

DBCC FREESESSIONCACHE

sys.fn_all_changes_<capture_instance>

DBCC FREESYSTEMCACHE

sys.fn_builtin_permissions

DBCC HELP

sys.fn_cdc_decrement_lsn

DBCC INDEXDEFRAG

sys.fn_cdc_get_column_ordinal

DBCC INPUTBUFFER

sys.fn_cdc_get_max_lsn

DBCC OPENTRAN

sys.fn_cdc_get_min_lsn

DBCC OUTPUTBUFFER

sys.fn_cdc_has_column_changed

DBCC PROCCACHE

sys.fn_cdc_increment_lsn

DBCC SHOWCONTIG

sys.fn_cdc_is_bit_set

DBCC SHRINKDATABASE

sys.fn_cdc_map_lsn_to_time

DBCC SHRINKFILE

sys.fn_cdc_map_time_to_lsn

DBCC SQLPERF

sys.fn_check_object_signatures

DBCC TRACEOFF

sys.fn_net_changes_<capture_instance>

DBCC TRACEON

sys.fn_translate_permissions

DBCC TRACESTATUS

sys.fn_validate_plan_guide

DBCC UPDATEUSAGE

sys.fn_xe_file_target_read_file

DBCC USEROPTIONS

sys.login_token

DECRYPTBYASYMKEY

sys.user_token

DECRYPTBYCERT

sys.fn_validate_plan_guide

DECRYPTBYKEY

sys.fn_xe_file_target_read_file

DECRYPTBYKEYAUTOASYMKEY

sys.login_token

DECRYPTBYKEYAUTOCERT

sys.numbered_procedure_parameters

DECRYPTBYPASSPHRASE

sys.numbered_procedures

ENCRYPTBYASYMKEY

sys.user_token

ENCRYPTBYCERT

UPDATETEXT

ENCRYPTBYKEY

VERIFYSIGNEDBYASYMKEY

ENCRYPTBYPASSPHRASE

VERIFYSIGNEDBYCERT

END CONVERSATION

WITH CHANGE_TRACKING_CONTEXT

EVENTDATA

WITH XMLNAMESPACES

fn_get_audit_file

WRITETEXT

fn_get_sql

XML_SCHEMA_NAMESPACE

fn_syscollector_get_execution_details

ImportantImportante
Para obter mais informações sobre gramática, uso e exemplos de Transact-SQL, consulte Referência de Transact-SQL (Mecanismo de Banco de Dados) nos Manuais Online do SQL Server.

Consulte também

Isso foi útil para você?
(1500 caracteres restantes)
Agradecemos os seus comentários
Mostrar:
© 2014 Microsoft