Database Reference
In-Depth Information
CREATE/DROP/ALTER PARTITION FUNCTION
RECONFIGURE
CREATE/DROP/ALTER QUEUE
RESTORE
CREATE/DROP/ALTER RESOURCE POOL
SELECT INTO Clause
CREATE/DROP/ALTER SERVICE
SET ANSI_DEFAULTS
CREATE/DROP/ALTER XML SCHEMA COLLECTION
SET ANSI_NULLS
DBCC CHECKALLOC
SET ANSI PADDING_OFF
DBCC CHECKDB
SET OFFSETS
DBCC CHECKIDENT
WITH XML NAMESPACES
Supported Data Types
If you've been following SQL Azure since its initial release to the public, you realize that Microsoft has
come a long way in supporting much of the functionality and many of the data types found in your local,
on-premises instance of SQL Server. Table B-4 lists those data types currently supported in SQL Azure as
of Service Update 4.
Table B-4.
SQL Azure Supported Data Types
Numerics
bigint
bit
decimal
int
money
numeric
smallint
smallmoney
tinyint
float
