New T-SQL Features in SQL Server 2012

 

In every version of SQL Server new T-SQL features are introduced. These are new T-SQL features of SQL Server 2012.

• Sequences
• Function
  • String function CONCAT,FORMAT
  • Logical function CHOOSE,IIF
  • Date & time function
    • DATEFROMPARTS
    • DATETIMEFROMPARTS
    • DATETIME2FROMPARTS
    • DATETIMEOFFSETFROMPARTS
    • SMALLDATETIMEFROMPARTS
    • TIMEFROMPARTS
    • EOMONTH
  • Conversion function
    • PARSE
    • TRY_CONVERT
    • TRY_PARSE

• Paging Data

• Lag & Lead

• Exception handling

• WithResultSets