SQL 2022 Tutorials | New Features of SQL 2022 | What's new in SQL 2022 | sql 2022 new features

This video talks about
New Features of SQL 2022
Whats new in SQL 2022
What's new feature SQL Server 2022

a. Series functions
Generate_series() 1,100 ,2
First_Value()
Last_Value()
Date_bucket
DateTrunc()
b. T SQL Functions :
Greatest() 23,45,78,12
'Training2sql','abc','def'
Least()
string_split ('I am watching training2sql videos',' ',1)
1 ,I
2,am
3, watching
c. Select window :
over (partition by dept order by designation)
d. Create Statitics Auto Drop option
e. Resumable add table constraints
f. Is DISTINCT FROM