Database Reference
In-Depth Information
[PWD] [varbinary](100) NULL,
[rowguid] [uniqueidentifier] NULL,
PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF))
For detailed information about exactly what is supported and what isn't, visit
http://msdn.microsoft.com/en-us/library/ee336267.aspx
.
Unsupported T-SQL
The list of unsupported T-SQL statements is long, but that isn't as negative a thing as it may appear. In
most cases, unsupported statements are operating-system or hardware related, and they don't apply in
the SQL Azure environment.
Because there are so many unsupported statements, this appendix doesn't list them all. You can
find a complete list at
http://msdn.microsoft.com/en-us/library/ee336253.aspx
. Table B-3 provides a
shorter list, highlighting some unsupported statements that you should particularly be aware of.
Table B-3.
Unsupported T-SQL Statements
BACKUP CERTIFICATE
DBCC CHECKTABLE
BACKUP MASTER KEY
DBCC DBREINDEX
BACKUP SERVICE MASTER KEY
DBCC DROPCLEANBUFFERS
CHECKPOINT
DBCC FREEPROCCACHE
CONTAINS
DBCC HELP
CREATE/DROP AGGREGATE
DBCC PROCCACHE
CREATE/DROP RULE
DBCC SHOWCONTIG
CREATE/DROP XML INDEX
DBCC SQLPERF
CREATE/DROP/ALTER APPLICATION ROLE
DBCC USEROPTIONS
CREATE/DROP/ALTER ASSEMBLY
KILL
CREATE/DROP/ALTER CERTIFICATE
NEWSEQUENTIALID
CREATE/DROP/ALTER DEFAULT
OPENQUERY
CREATE/DROP/ALTER FULLTEXT
(
CATALOG
,
INDEX
,
STOPLIST)
OPENXML
