Top new T-SQL features in SQL Server 2012

Top new T-SQL features in SQL Server 2012 

In the Previous chapter we have learnt about what is Transact-SQL. In this chapter we will learn all features and methods of transact-SQL. This is one of the best SQL Server Interview Question. 

1.   WITH RESULT SETS

2.   OFFSET AND FETCH

3.   THROW in Error handling

4.   SEQUENCE

5.   Function

a.   String function

                                          i.    CONCAT()

                                        ii.    FORMAT()

b.   Logical function

                                          i.    CHOOSE()

                                        ii.    IIF()

c.   Date & time function

                                         i.    DATEFROMPARTS ()

                                        ii.    DATETIMEFROMPARTS()

                                       iii.    DATETIME2FROMPARTS()

                                      iv.    DATETIMEOFFSETFROMPARTS ()

                                       v.    SMALLDATETIMEFROMPARTS()

                                      vi.    TIMEFROMPARTS()

                                     vii.    EOMONTH()

d.   Conversion function

                                         i.    PARSE ()

                                        ii.    TRY_CONVERT ()

                                       iii.    TRY_PARSE ()

e.   Analytical Functions

                                          i.    LAG()

                                        ii.    LEAD()

                                       iii.    LAST_VALUE()

                                      iv.    FIRST_VALUE()

                                        v.    CUME_DIST()

                                      vi.    PERCENTILE_DISC ()

                                     vii.    PERCENT_RANK()

                                    viii.     PERCENTILE_CONT()

If you have any queries or suggestions, please feel free to ask in comments section.