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