sql server new features

Sample script for

1. using comman type expression (CTE)
2. Pivot
3. cross apply
4. row_number
   
5. rank
6. dense_rank
7. top
8. Try/Catch Error Handling
9. FOR XML PATH
10. view
    
11. function

sql server new features