New T-SQL language features
Fecha de actualización: lunes, 15 de mayo de 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.