Esporta (0) Stampa
Espandi tutto

Istruzioni Transact-SQL non supportate (database SQL di Azure)

Aggiornamento: febbraio 2014

Questo argomento è OBSOLETO. La versione più recente è disponibile in Guida di riferimento a Transact-SQL 14.

Microsoft Database SQL di Microsoft Azure non supporta tutte le istruzioni Transact-SQL sfornite in SQL Server 2014. La tabella seguente riporta un elenco delle istruzioni Transact-SQL non supportate dal Database SQL di Microsoft Azure .

ImportantImportante
Per ulteriori informazioni sulla grammatica, sull'utilizzo e sugli esempi di Transact-SQL, vedere Guida di riferimento a Transact-SQL (Motore di database) nella documentazione online di SQL Server.

 

$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>

GRANT/REVOKE/DENY - autorizzazioni per assembly

cdc.fn_cdc_get_net_changes_<capture_instance>

GRANT/REVOKE/DENY - autorizzazioni per chiavi asimmetriche

CERT_ID

GRANT/REVOKE/DENY - autorizzazioni per certificati

CERTPROPERTY

GRANT/REVOKE/DENY - autorizzazioni per endpoint

CHANGE_TRACKING_CURRENT_VERSION

GRANT/REVOKE/DENY - autorizzazioni per catalogo full-text

CHANGE_TRACKING_IS_COLUMN_IN_MASK

GRANT/REVOKE/DENY - autorizzazioni per server

CHANGE_TRACKING_MIN_VALID_VERSION

GRANT/REVOKE/DENY - autorizzazioni per entità server

CHANGETABLE

GRANT/REVOKE/DENY - autorizzazioni per Service Broker

CHECKPOINT

GRANT/REVOKE/DENY - autorizzazioni per chiavi simmetriche

CLOSE MASTER KEY

GRANT/REVOKE/DENY - autorizzazioni per oggetti di sistema

CLOSE SYMMETRIC KEY

GRANT/REVOKE/DENY - autorizzazioni per raccolte XML Schema

CALCOLO

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

Clausola 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

ARRESTA

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

Vedere anche

Mostra:
© 2014 Microsoft