Eksporter (0) Skriv ut
Vis alt
EN
Dette innholdet er ikke tilgjengelig på ditt språk, men her er den engelske versjonen.

Supported Transact-SQL Statements (Azure SQL Database)

Updated: February 21, 2014

The following Microsoft Azure SQL Database Transact-SQL statements provide the same functionality as the corresponding SQL Server Transact-SQL statements.

ImportantImportant
For more information about Transact-SQL grammar, usage, and examples, see Transact-SQL Reference (Database Engine) in SQL Server Books Online.

 

ALTER ROLE

DELETE

OPEN

ALTER SCHEMA

DENY Object Permissions

OPTION Clause

ALTER VIEW

DENY Schema Permissions

ORDER BY Clause

APPLOCK_MODE

DROP LOGIN

OUTPUT Clause

APPLOCK_TEST

DROP PROCEDURE

OVER Clause

BEGIN TRANSACTION

DROP ROLE

PRINT

BEGIN...END

DROP SCHEMA

RAISERROR

BINARY_CHECKSUM

DROP STATISTICS

RETURN

BREAK

DROP SYNONYM

REVERT

CAST and CONVERT

DROP TYPE

REVOKE Object Permissions

TRY...CATCH

DROP USER

REVOKE Schema Permissions

CEILING

DROP VIEW

ROLLBACK WORK

CHECKSUM

END (BEGIN...END)

SAVE TRANSACTION

CLOSE

EXCEPT and INTERSECT

SELECT @local_variable

COALESCE

FETCH

SELECT Clause

COLUMNPROPERTY

FOR Clause

SET @local_variable

COMMIT TRANSACTION

FROM

SWITCHOFFSET

COMMIT WORK

GO

THROW

CONTEXT_INFO

GOTO

TERTIARY_WEIGHTS

CONTINUE

GRANT Object Permissions

TODATETIMEOFFSET

CONVERT

GRANT Schema Permissions

TOP

CREATE ROLE

GROUP BY

TRIGGER_NESTLEVEL

CREATE SCHEMA

GROUPING_ID

TRUNCATE TABLE

CREATE STATISTICS

HASHBYTES

TRY...CATCH

CREATE VIEW

HAVING

UNION

CRYPT_GEN_RANDOM

Hints

noteNote
Includes Query, Table, and Join Hints. For more information, see Support for Hints.

UPDATE

CURRENT_REQUEST_ID

IDENTITY (Property)

UPDATE STATISTICS

CURSOR_STATUS

IF...ELSE

USER

DBCC SHOW_STATISTICS

INSERT BULK

WAITFOR

DEALLOCATE

IS [NOT] NULL

WHERE

DECLARE @local_variable

MERGE

WHILE

DECLARE CURSOR

MIN_ACTIVE_ROWVERSION

WITH common_table_expression

Support for Hints

Hints are options or strategies specified for enforcement by the underlying query processor on SELECT, INSERT, UPDATE, DELETE, or MERGE statements. Microsoft Azure SQL Database supports all the Query, Table, and Join Hints provided by SQL Server with a few exceptions. When running queries, Microsoft Azure SQL Database always sets the max degree of parallelism to 1 automatically and ignores the MAXDOP hint even if it is used. In addition, SQL Database does not support the PAGLOCK table hint.

For more information, see Hints (Transact-SQL) and max degree of parallelism Option.

Support for SET statements

The Transact-SQL programming language provides several SET statements that change the current session handling of specific information.

The following table provides a list of SET statements supported by Microsoft Azure SQL Database.

 

SET Statement Category Statement

Date and time statements

SET DATEFIRST

SET DATEFORMAT

Locking statements

SET DEADLOCK_PRIORITY

SET LOCK_TIMEOUT

Miscellaneous statements

SET CURSOR_CLOSE_ON_COMMIT

SET FIPS_FLAGGER

SET IDENTITY_INSERT

SET LANGUAGE

SET QUOTED_IDENTIFIER

Query Execution Statements

SET ARITHABORT

SET ARITHIGNORE

SET NOCOUNT

SET NOEXEC

SET NUMERIC_ROUNDABORT

SET PARSEONLY

SET ROWCOUNT

SET TEXTSIZE

ISO Settings statements

SET ANSI_NULL_DFLT_OFF

SET ANSI_NULL_DFLT_ON

SET ANSI_PADDING

SET ANSI_WARNINGS

Statistics statements

SET FORCEPLAN

SET SHOWPLAN_ALL

SET SHOWPLAN_TEXT

SET SHOWPLAN_XML

SET STATISTICS IO

SET STATISTICS PROFILE

SET STATISTICS TIME

SET STATISTICS XML

Transactions statements

SET IMPLICIT_TRANSACTIONS

SET TRANSACTION ISOLATION LEVEL

SET XACT_ABORT

See Also

Fellesskapsinnhold

Legg til
Vis:
© 2014 Microsoft