New T-SQL language features

미리 보기 현재 미리 보기로 제공됩니다.

업데이트된 날짜: 2017년 5월 15일 월요일

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.

관련 피드백