SQL Server 2022 is in preview and I wrote a previous article on the T-SQL language changes. This article is a second part, covering a few more of the changes in T-SQL that are coming with this new version of the database platform.
The first article looked at DISTINCT FROM, DATE_BUCKET, GENERATE_SERIES, GREATEST/LEAST, STRING_SPLIT, and DATETRUNC. The second article covered APPROX_PERCENTILE_CONT, APPROX_PERCENTILE_DISC, and the bit manipulation functions, along with changes to the FIRST_VALUE, LAST_VALUE, and LTRIM/RTRIM/TRIM changes. This article looks at JSON features.
This is a light look at these language features, as I am still experimenting and learning about