Aaron Bertrand notes some T-SQL improvements:
A few of the most useful changes I’ve been able to play with in SQL Server 2022 so far:
– GREATEST / LEAST
– STRING_SPLIT
– DATE_BUCKET
– GENERATE_SERIES
In this tip, I’ll explain each one, and show some practical use cases.
Click through for more information. I particularly like GREATEST() and LEAST() but GENERATE_SERIES() could be very useful as well. Some of this stuff was first made available in Azure SQL Edge.