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 previous article looked at DISTINCT FROM, DATE_BUCKET, GENERATE_SERIES, GREATEST/LEAST, STRING_SPLIT, and DATETRUNC. In this article, I’ll cover APPROX_PERCENTILE_CONT, APPROX_PERCENTILE_DISC and the bit manipulation functions. I’ll also look at changes in FIRST_VALUE, LAST_VALUE, and LTRIM/RTRIM/TRIM changes.
This is a light look at these language features, as I am still experimenting and learning about them. My evaluation of SQL