Database Reference
In-Depth Information
A P P E N D I X B
SQL Azure Quick Reference
SQL Azure supports T-SQL. Chances are, you're already familiar with SQL Server T-SQL syntax if you're
reading this topic. However, the topic includes this appendix because not everything you know and love
about SQL Server is supported yet in SQL Azure. This appendix provides a quick reference to the syntax
that is currently supported in SQL Azure as of Service Update 4.
Note You can find a complete list and reference that describes T-SQL supported in SQL Azure at
http://msdn.microsoft.com/en-us/library/ee336281.aspx .
Supported T-SQL
Table B-1 lists the supported T-SQL statements that you can use in SQL Azure. These statements can be
used as exactly as you currently know them without any limitations.
Table B-1. Fully Supported T-SQL Statements
ALTER ROLE
DECLARE CURSOR
OPEN
ALTER SCHEMA
DELETE
OPTION Clause
ALTER VIEW
DENY Object Permissions
ORDER BY Clause
APPLOCK_MODE
DENY Schema Permissions
OUTPUT Clause
APPLOCK_TEST
DROP LOGIN
OVER Clause
BEGIN_TRANSACTION
DROP PROCEDURE
PRINT
BEGIN…END
DROP ROLE`
RAISERROR
BINARY_CHECKSUM
DROP SCHEMA
RETURN
BREAK
DROP STATISTICS
REVERT
Search WWH ::




Custom Search