Learn how developers can use new T-SQL language enhancements

  • 2 minutes

SQL Server 2022 includes enhancements to the T-SQL language for JSON, core engine T-SQL scenarios, and processing time series data. For more information with examples, see Transact-SQL Reference.

Using T-SQL with JSON

SQL Server 2022 introduces new and enhanced T-SQL functions to work with JSON data, including:

  • ISJSON
  • JSON_PATH_EXISTS
  • JSON_OBJECT
  • JSON_ARRAY

Core surface area T-SQL enhancements

SQL Server 2022 includes new and enhanced T-SQL functions and statements for core engine scenarios including:

  • GREATEST
  • LEAST
  • STRING_SPLIT
  • TRIM functions
  • DATETRUNC
  • IS [NOT] DISTINCT FROM
  • WINDOW clause
  • LEFT_SHIFT
  • RIGHT_SHIFT
  • BIT_COUNT
  • GET_BIT
  • SET_BIT

Using T-SQL with time series data

SQL Server 2022 provides new T-SQL functions to process data time series types of data including:

  • DATE_BUCKET
  • GENERATE_SERIES
  • FIRST_VALUE
  • LAST_VALUE