Databases Reference
In-Depth Information
Table B-1.
(
continued
)
CATCH (TRY...CATCH)
DROP VIEW
ROLLBACK WORK
CEILING
END (BEGIN...END)
SAVE TRANSACTION
CHECKSUM
EXCEPT and INTERSECT
SELECT @
local_variable
CLOSE
FETCH
SELECT
Clause
COALESCE
FOR
Clause
(XML and BROWSE)
SET @
local_variable
COLUMNPROPERTY
FROM
SWITCHOFFSET
COMMIT TRANSACTION
GO
TERTIARY_WEIGHTS
COMMIT WORK
GOTO
THROW
CONTEXT_INFO
GRANT
Object Permissions
TODATETIMEOFFSET
CONTINUE
GRANT
Schema Permissions
TOP
CONVERT
GROUP BY
TRIGGER_NESTLEVEL
CREATE ROLE
GROUPING_ID
TRUNCATE TABLE
CREATE SCHEMA
HashBytes
TRY...CATCH
CREATE STATISTICS
HAVING
UNION
CREATE VIEW
Hints (Query, Table, Join,
etc.)
UPDATE
CRYPT_GEN_RANDOM
IDENTITY (
Property
)
UPDATE STATISTICS
CURRENT_REQUEST_ID
IF...ELSE
USER
CURSOR_STATUS
INSERT BULK
SWITCHOFFSET
DBCC SHOW_STATISTICS
IS [NOT] NULL
WAITFOR
DEALLOCATE
MERGE
WHERE
DECLARE @local_variable
MIN_ACTIVE_ROWVERSION
WHILE
DECLARE CURSOR
OPEN
WITH (
Common Table Expression
)
DELETE
OPTION Clause
Partially Supported T-SQL Statements
Table
B-2
lists the partially supported T-SQL statements that you can use in Windows Azure SQL Database. “Partially
supported” means you can use these statements, but with some variations (or limitations) to the syntax. Examples are
provided following the table.
