Exporteren (0) Afdrukken
Alles uitvouwen
EN
Deze inhoud is niet beschikbaar in uw taal, maar wel in het Engels.

Azure SQL Database Support for Programmability Enhancements in SQL Server 2012

Updated: February 10, 2014

This topic is OBSOLETE. You can find the most current version in the SQL 14 Transact-SQL Reference.

Microsoft Microsoft Azure SQL Database supports some, but not all, of the programmability enhancements made in the SQL Server 2012 Database Engine. This topic describes which SQL Server 2012 programmability enhancements are supported in Microsoft Azure SQL Database, and which are not.

ImportantImportant
For more information about Transact-SQL grammar, usage, and examples, see Transact-SQL Reference (Database Engine) in SQL Server Books Online.

SQL Server 2012 Programmability Enhancements Supported by SQL Database

The following table provides a list of the SQL Server 2012 programmability enhancements that Microsoft Azure SQL Database supports.

 

Enhancement

Support in Azure SQL Database and SQL Server 2012

OFFSET … FETCH

Supported in ORDER BY clause.

Error Handling: THROW

Supported.

Metadata discovery

Microsoft Azure SQL Database supports the use of management functions sp_describe_first_result_set and sp_describe_undeclared_parameters in place of SET FMTONLY to determine the format of a response without actually running the query are not supported.

EXEC … WITH RESULT SETS {…}

Supported in enforcing contracts for result sets for the EXEC command.

New Conversion Functions

Microsoft Azure SQL Database supports TRY_CAST for converting for all types, and it supports FORMAT, PARSE, and TRY_PARSE for converting to and from strings.

The TRY_CONVERT conversion function is supported in SQL Server 2012, but is not supported in Microsoft Azure SQL Database.

New String Functions

The CONCAT string function is supported in Microsoft Azure SQL Database.

New Date and Time Related Functions

Microsoft Azure SQL Database supports DATEFROMPARTS, DATETIME2FROMPARTS, DATETIMEFROMPARTS, DATETIMEOFFSETFROMPARTS, EOMONTH, SMALLDATETIMEFROMPARTS, TIMEFROMPARTS.

New Logical Functions

Microsoft Azure SQL Database supports IIF and CHOOSE.

New Spatial Features

Microsoft Azure SQL Database supports enhancements to spatial data types; new and updated methods and aggregates for geometry and geography; improved precision, enhancements to the geography type; spatial performance improvements; spatial helper stored procedures; support for persisted computed columns; and changes in the client-side spatial programming library.

Query Optimizer

The enhanced query optimizer hints, FORCESEEK and FORCESCAN, are supported.

SQL Server 2012 Programmability Enhancements Not Supported by SQL Database

The following table provides a list of the SQL Server 2012 programmability enhancements that Microsoft Azure SQL Database does not support.

 

Enhancement

Support in SQL Server 2012, but not Azure SQL Database

FileTables

Supported for the Windows file namespace and compatibility with Windows application to the file data stored in SQL Server.

Statistical Semantic Search

Supported for insight into unstructured documents stored in Azure SQL Databases, with results available as structured data through three T-SQL rowset functions.

Full-Text Search

Property search, customizable NEAR, and new word breakers and stemmers.

UTF-16 Support

UTF-16 supplementary characters collations, and supplementary characters collation option for XML.

Sequence Objects

A user-defined schema-bound object that generates a sequence of numeric values according to the specification with which the sequence was created.

New Extended Events

Extensions to page_allocated, page_freed, allocation_failure, resource_monitor_ring_buffer_record, and memory_node_oom_ring_buffer_recorder.

OVER Clause enhancements

Extension to support window functions.

New analytic functions

CUME_DIST, FIRST_VALUE, LAG, LAST_VALUE, LEAD, PERCENTILE_CONT, PERCENTILE_DISC, PERCENT_RANK

Community-inhoud

Weergeven:
© 2014 Microsoft