New T_SQL Features introdued in sqlserver 2012

CONCAT

http://msdn.microsoft.com/en-us/library/hh231515.aspx

FORMAT 

http://msdn.microsoft.com/en-us/library/hh213505.aspx

PARSE 

http://msdn.microsoft.com/en-us/library/hh213316.aspx

TRY_CAST 

http://msdn.microsoft.com/en-us/library/hh974669.aspx

TRY_CONVERT

http://msdn.microsoft.com/en-us/library/hh230993.aspx

TRY_PARSE 

http://msdn.microsoft.com/en-us/library/hh213126.aspx

FILETABLES 
http://msdn.microsoft.com/en-us/library/ff929144.aspx

THROW

http://msdn.microsoft.com/en-us/library/ee677615.aspx

LAG
http://msdn.microsoft.com/en-us/library/hh231256.aspx

LEAD

http://msdn.microsoft.com/en-us/library/hh213125.aspx

LAST_VALUE

http://msdn.microsoft.com/en-us/library/hh231517.aspx

FIRST_VALUE

http://msdn.microsoft.com/en-us/library/hh213018.aspx

CUME_DIST

http://msdn.microsoft.com/en-us/library/hh231078.aspx

 

 

PERCENTILE_CONT 

http://msdn.microsoft.com/en-us/library/hh231473.aspx

PERCENTILE_DISC 

http://msdn.microsoft.com/en-us/library/hh231327.aspx

PERCENT_RANK 

http://msdn.microsoft.com/en-us/library/hh213573.aspx