내보내기(0) 인쇄
모두 확장

지원되지 않는 Transact-SQL 문(Azure SQL 데이터베이스)

업데이트 날짜: 2014년 2월

이 항목은 더 이상 사용되지 않습니다. SQL 14 Transact-SQL 참조(영문)에서 최신 버전을 찾을 수 있습니다.

Microsoft에서 제공하는 모든 Microsoft Azure SQL 데이터베이스 문이 Transact-SQL SQL Server 2008에서 지원되지는 않습니다. 다음 표는 Transact-SQL에서 지원하지 않는 Microsoft Azure SQL 데이터베이스 문의 목록을 보여줍니다.

 

$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 어셈블리 권한

cdc.fn_cdc_get_net_changes_<capture_instance>

GRANT/REVOKE/DENY 비대칭 키 권한

CERT_ID

GRANT/REVOKE/DENY 인증서 권한

CERTPROPERTY

GRANT/REVOKE/DENY 끝점 권한

CHANGE_TRACKING_CURRENT_VERSION

GRANT/REVOKE/DENY 전체 텍스트 카탈로그 권한

CHANGE_TRACKING_IS_COLUMN_IN_MASK

GRANT/REVOKE/DENY 서버 권한

CHANGE_TRACKING_MIN_VALID_VERSION

GRANT/REVOKE/DENY 서버 보안 주체 권한

CHANGETABLE

GRANT/REVOKE/DENY Service Broker 권한

CHECKPOINT

GRANT/REVOKE/DENY 대칭 키 권한

CLOSE MASTER KEY

GRANT/REVOKE/DENY 시스템 개체 권한

CLOSE SYMMETRIC KEY

GRANT/REVOKE/DENY XML 스키마 컬렉션 권한

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

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

Important중요
Transact-SQL 문법, 사용법 및 예제에 대한 자세한 내용은 SQL Server 온라인 설명서의 Transact-SQL 참조(데이터베이스 엔진)를 참조하십시오.

참고 항목

커뮤니티 추가 항목

추가
표시:
© 2014 Microsoft