06_TSQL.md

Workshop: SQL Server 2022 Workshop

A Microsoft workshop from the SQL Server team

SQL Server 2022 enhancements to T-SQL

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:

Exercises

You will cover the following topics in this Module:

6.0 Process JSON data with T-SQL

6.1 Explore new core T-SQL enhancements

6.2 Process time series data with T-SQL

6.3 Using bit manipulation T-SQL functions in SQL Server

6.0 Process JSON data with T-SQL

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

ISJSON
JSON_PATH_EXISTS
JSON_OBJECT
JSON_ARRAY

Exercise: Explore enhancements to process JSON data in SQL Server

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

6.1 Explore new core 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

Exercise: Explore new core T-SQL enhancements

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

6.2 Process time series data with T-SQL

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

DATE_BUCKET
GENERATE_SERIES
FIRST_VALUE

Exercise: Learn how to process time series data with SQL Server

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

6.3 Bit manipulation with T-SQL

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

Exercise: Learn bit manipulation using T-SQL with SQL Server

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