Roberto Brunetti

Developing in the cloud

.NET Programming

Archives

SQL Azure: TSQL

Questo l’elenco degli statement TSQL non supportati dalla prima versione di SQL Azure.

$PARTITION

ADD SIGNATURE

ALTER DATABASE

ALTER RESOURCE GOVERNOR

ALTER SERVICE MASTER KEY

ASSEMBLYPROPERTY

ASYMKEY_ID

ASYMKEYPROPERTY

BACKUP

BACKUP CERTIFICATE

BACKUP MASTER KEY

BACKUP SERVICE MASTER KEY

BEGIN CONVERSATION TIMER

BEGIN DIALOG CONVERSATION

BEGIN DISTRIBUTED TRANSACTION

BULK INSERT

cdc.fn_cdc_get_all_changes_<capture_instance>

cdc.fn_cdc_get_net_changes_<capture_instance>

CERT_ID

CERTPROPERTY

CHANGE_TRACKING_CURRENT_VERSION

CHANGE_TRACKING_IS_COLUMN_IN_MASK

CHANGE_TRACKING_MIN_VALID_VERSION

CHANGETABLE

CHECKPOINT

CLOSE MASTER KEY

CLOSE SYMMETRIC KEY

CONNECTIONPROPERTY

CONTAINS

CONTAINSTABLE

CREATE/ALTER/DROP APPLICATION ROLE

CREATE/ALTER/DROP ASSEMBLY

CREATE/ALTER/DROP ASYMMETRIC KEY

CREATE/ALTER/DROP BROKER PRIORITY

CREATE/ALTER/DROP CERTIFICATE

CREATE/ALTER/DROP CONTRACT

CREATE/ALTER/DROP CREDENTIAL

CREATE/ALTER/DROP CRYPTOGRAPHIC PROVIDER

CREATE/ALTER/DROP DATABASE AUDIT SPECIFICATION

CREATE/ALTER/DROP DATABASE ENCRYPTION KEY

CREATE/ALTER/DROP DEFAULT

CREATE/ALTER/DROP ENDPOINT

CREATE/ALTER/DROP EVENT NOTIFICATION

CREATE/ALTER/DROP EVENT SESSION

CREATE/ALTER/DROP FULLTEXT CATALOG

CREATE/ALTER/DROP FULLTEXT INDEX

CREATE/ALTER/DROP FULLTEXT STOPLIST

CREATE/ALTER/DROP LOGIN

CREATE/ALTER/DROP MASTER KEY

CREATE/ALTER/DROP MESSAGE TYPE

CREATE/ALTER/DROP PARTITION FUNCTION

CREATE/ALTER/DROP PARTITION SCHEME

CREATE/ALTER/DROP QUEUE

CREATE/ALTER/DROP REMOTE SERVICE BINDING

CREATE/ALTER/DROP RESOURCE POOL

CREATE/ALTER/DROP ROUTE

CREATE/ALTER/DROP SERVER AUDIT

CREATE/ALTER/DROP SERVER AUDIT SPECIFICATION

CREATE/ALTER/DROP SERVICE

CREATE/ALTER/DROP SPATIAL INDEX

CREATE/ALTER/DROP SYMMETRIC KEY

CREATE/ALTER/DROP WORKLOAD GROUP

CREATE/ALTER/DROP XML SCHEMA COLLECTION

CREATE/DROP RULE

CREATE/DROP TYPE

CREATE/DROP XML INDEX

DATABASEPROPERTY

DBCC CHECKALLOC

DBCC CHECKCATALOG

DBCC CHECKCONSTRAINTS

DBCC CHECKDB

DBCC CHECKFILEGROUP

DBCC CHECKIDENT

DBCC CHECKTABLE

DBCC CLEANTABLE

DBCC DBREINDEX

DBCC dllname

DBCC DROPCLEANBUFFERS

DBCC FREEPROCCACHE

DBCC FREESESSIONCACHE

DBCC FREESYSTEMCACHE

DBCC HELP

DBCC INDEXDEFRAG

DBCC INPUTBUFFER

DBCC OPENTRAN

DBCC OUTPUTBUFFER

DBCC PROCCACHE

DBCC SHOWCONTIG

DBCC SHRINKDATABASE

DBCC SHRINKFILE

DBCC SQLPERF

DBCC TRACEOFF

DBCC TRACEON

DBCC TRACESTATUS

DBCC UPDATEUSAGE

DBCC USEROPTIONS

DECRYPTBYASYMKEY

DECRYPTBYCERT

DECRYPTBYKEY

DECRYPTBYKEYAUTOASYMKEY

DECRYPTBYKEYAUTOCERT

DECRYPTBYPASSPHRASE

ENCRYPTBYASYMKEY

ENCRYPTBYCERT

ENCRYPTBYKEY

ENCRYPTBYPASSPHRASE

END CONVERSATION

EVENTDATA

fn_get_audit_file

fn_get_sql

fn_syscollector_get_execution_details

fn_syscollector_get_execution_stats

fn_trace_geteventinfo

fn_trace_getinfo

fn_trace_gettable

fn_virtualfilestats

fn_virtualservernodes

FREETEXT

FREETEXTTABLE

FULLTEXTCATALOGPROPERTY

FULLTEXTSERVICEPROPERTY

GET CONVERSATION GROUP

GET_FILESTREAM_TRANSACTION_CONTEXT

GET_TRANSMISSION_STATUS

GRANT/REVOKE/DENY ALL

GRANT/REVOKE/DENY ALL PRIVILEGES

GRANT/REVOKE/DENY Assembly Permissions

GRANT/REVOKE/DENY Asymmetric Key Permissions

GRANT/REVOKE/DENY Certificate Permissions

GRANT/REVOKE/DENY Endpoint Permissions

GRANT/REVOKE/DENY Full-text Catalog Permissions

GRANT/REVOKE/DENY Server Permissions

GRANT/REVOKE/DENY Server Principal Permissions

GRANT/REVOKE/DENY Service Broker Permissions

GRANT/REVOKE/DENY Symmetric Key Permissions

GRANT/REVOKE/DENY System Object Permissions

GRANT/REVOKE/DENY Type Permissions

GRANT/REVOKE/DENY XML Schema Collection Permissions

HAS_DBACCESS

INDEXKEY_PROPERTY

IS_OBJECTSIGNED

KEY_GUID

KEY_ID

KEY_NAME

KILL

KILL QUERY NOTIFICATION SUBSCRIPTION

KILL STATS JOB

LOGINPROPERTY

MOVE CONVERSATION

NEWSEQUENTIALID

OBJECT_DEFINITION

OPEN MASTER KEY

OPEN SYMMETRIC KEY

OPENDATASOURCE

OPENQUERY

OPENROWSET

OPENXML

ORIGINAL_DB_NAME

ORIGINAL_LOGIN

PathName

PUBLISHINGSERVERNAME

READTEXT

RECEIVE

RECONFIGURE

RESTORE

RESTORE FILELISTONLY

RESTORE HEADERONLY

RESTORE LABELONLY

RESTORE MASTER KEY

RESTORE REWINDONLY

RESTORE SERVICE MASTER KEY

RESTORE VERIFYONLY

SELECT INTO Clause

SEND

SET ANSI_DEFAULTS

SET ANSI_NULLS

SET ANSI_PADDING

SET CONCAT_NULL_YIELDS_NULL

SET DISABLE_DEF_CNST_CHK

SET OFFSETS

SET QUERY_GOVERNOR_COST_LIMIT

SET REMOTE_PROC_TRANSACTIONS

SETUSER

SHUTDOWN

SIGNBYASYMKEY

SIGNBYCERT

snapshots.fn_trace_getdata

SYMKEYPROPERTY

sys.fn_all_changes_<capture_instance>

sys.fn_builtin_permissions

sys.fn_cdc_decrement_lsn

sys.fn_cdc_get_column_ordinal

sys.fn_cdc_get_max_lsn

sys.fn_cdc_get_min_lsn

sys.fn_cdc_has_column_changed

sys.fn_cdc_increment_lsn

sys.fn_cdc_is_bit_set

sys.fn_cdc_map_lsn_to_time

sys.fn_cdc_map_time_to_lsn

sys.fn_check_object_signatures

sys.fn_net_changes_<capture_instance>

sys.fn_translate_permissions

sys.fn_validate_plan_guide

sys.fn_xe_file_target_read_file

sys.login_token

sys.user_token

sys.fn_validate_plan_guide

sys.fn_xe_file_target_read_file

sys.login_token

sys.user_token

UPDATETEXT

VERIFYSIGNEDBYASYMKEY

VERIFYSIGNEDBYCERT

WITH CHANGE_TRACKING_CONTEXT

WITH XMLNAMESPACES

WRITETEXT

XML_SCHEMA_NAMESPACE

 
Posted: ott 09 2009, 12:16 by rob | with no comments
Filed under: