SQL Server 2022 enhances the developer experience with the following enhancements to the T-SQL language:

• Enhancements and new T-SQL functions to process JSON data.
• Enhancements and new T-SQL functions for core T-SQL scenarios.
• New T-SQL functions to process time series data.

Watch this video on T-SQL enhancements in SQL Server 2022 on Data Exposed:

You will cover the following topics in this Module:

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

ISJSON
JSON_PATH_EXISTS
JSON_OBJECT
JSON_ARRAY

Follow the instructions in the readme.md file in the sql2022workshop\06_TSQL\json folder.

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

Follow the instructions in the readme.md file in the sql2022workshop\06_TSQL\surfacearea folder.

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

DATE_BUCKET
GENERATE_SERIES
FIRST_VALUE

Follow the instructions in the readme.md file in the sql2022workshop\06_TSQL\timeseries folder.

SQL Server 2022 provides new T-SQL functions to manipulate data at the bit level:

LEFT_SHIFT
RIGHT_SHIFT
BIT_COUNT
GET_BIT
SET_BIT

Follow the instructions in the readme.md file in the sql2022workshop\06_TSQL\bit folder.