New T-SQL language features

In preview Hier is nu een preview van beschikbaar.

Bijgewerkt op: maandag 15 mei 2017

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

  • Add computed columns in the memory-optimized tables. Computed columns will be able to contain any expression that is supported in natively compiled modules.
  • Add memory-optimized indexes on persisted computed columns.
  • Natively compiled modules will support new T-SQL operators and functions—all JSON functions and the CROSS APPLY operator will be available.

To get started with JSON functions, check out Azure SQL Database JSON features. You'll be able to use the same JSON functionalities that will be available in classic tables and stored procedures in memory-optimized tables and natively compiled modules.