Sunday, December 25, 2011

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

No comments:

Post a Comment