Public preview: New T-SQL language features

woensdag 28 december 2016

New T-SQL language features are available in memory-optimized tables and natively compiled stored procedures in premium tiers of Azure SQL Database. The following features have been added:

  • You can add computed columns in the memory-optimized tables. Computed columns can contain any expression that is supported in natively compiled modules.
  • You can add memory-optimized indexes on persisted computed columns.
  • Natively compiled modules support new T-SQL operators and functions:
    • All JSON functions are available in natively compiled modules.
    • You can use the CROSS APPLY operator in natively compiled modules.

Computed columns and the CROSS APPLY operator are existing features in classic tables and stored procedures that are now available in natively compiled modules. To get started with JSON functions, check out Azure SQL Database JSON features. You can use the same JSON functionalities that are available in classic tables and stored procedures in memory-optimized tables and natively compiled modules.

Gratis account

Leren en bouwen met $200 aan tegoed en blijven doorwerken

Start gratis

Visual Studio

Abonnees krijgen tot wel $1800 Azure-services per jaar

Activeer nu

Startups

Neem deel aan het BizSpark-programma en ontvang gratis Azure-services

Meer informatie