SQL Server 2012 - New T-SQL Enhancements
This video goes over the new enhancements to T-SQL in SQL Server 2012.
The SQL code used in the video is available at:
http://askadba.blogspot.com/2012/10/t...
SEQUENCE object
Logical Functions:
CHOOSE
IIF
Date and Time Functions:
DATEFROMPARTS
DATETIME2FROMPARTS
DATETIMEFROMPARTS
DATETIMEOFFSETFROMPARTS
SMALLDATETIMEFROMPARTS
TIMEFROMPARTS
EOMONTH
OFFSET and FETCH
Window Functions:
FIRST_VALUE
LAST_VALUE
LAG
LEAD
CUME_DIST
PERCENT_RANK
PERCENTILE_CONT
PERCENTILE_DISC
