Friday, November 6, 2009

T-SQL Features Supported by SQL Azure

Transact-SQL is a language that contains commands used to administer instances of SQL Server including creating and managing all objects in an instance of SQL Server, and inserting, retrieving, modifying, and deleting all data in tables. Applications can communicate with an instance of SQL Server by sending Transact-SQL statements to the server.
Transact-SQL is an extension of the language defined in the SQL standards published by the International Standards Organization (ISO) and the American National Standards Institute (ANSI).

Microsoft SQL Azure Database supports a subset of T-SQL for SQL Server.
The support for T-SQL reference in SQL Azure can be described in three main categories:
  1. Transact-SQL language elements that are supported as is.
  2. Transact-SQL language elements that are not supported.
  3. Transact-SQL language elements that provide a subset of the arguments and options in their corresponding Transact-SQL elements in SQL Server 2008.
The following sections summarizes the Transact-SQL support provided by SQL Azure:
T-SQL Features Supported or Partially supported by SQL Azure :
  • Constants 
  • Constraints
  • Cursors
  • Index management and rebuilding indexes
  • Local temporary tables
  • Reserved keywords
  • Stored procedures
  • Statistics management
  • Transactions
  • Triggers
  • Tables, joins, and table variables
  • Transact-SQL language elements such as
  • Create/drop databases
  • Create/alter/drop tables
  • Create/alter/drop users and logins and so on.
  • User-defined functions
  • Views, including sys.synonyms view
T-SQL Features Not Supported By SQL Azure :
  • Common Language Runtime (CLR)
  • Database file placement
  • Database mirroring
  • Distributed queries
  • Distributed transactions
  • Filegroup management
  • Global temporary tables
  • Spatial data and indexes
  • SQL Server configuration options
  • SQL Server Service Broker
  • System tables
  • Trace Flags Not supported
In future posts we will take a deeper look into these features, especially those features which are supported by SQL Azure but that provide a subset of the arguments and options


No comments:

Post a Comment