What are T-SQL Enhancements done in SQL Server 2008

Leave a comment (0) Go to comments

What are T-SQL Enhancements done in SQL Server 2008 ?

SQL Server 2008’s new statements, extend the T-SQL feature and functionality. Let’s understand What are T-SQL Enhancements done in SQL Server 2008 ?

  • Declare and Initialize Variables
  • Compound Assignment Operators
  • Row Constructors
  • CONVERT Enhancements
  • Composable DML
  • Object Dependencies
  • MERGE Statement
  • TABLE Value constructor
  • GROUPING SET
  • DDL Trigger Enhancements
  • Sparse Columns
  • Filtered Index
  • New Date and Time Functions
    • SYSDATETIME
    • SYSUTCDATETIME
    • SYSDATETIMEOFFSET
    • SWITCHOFFSET
    • TODATETIMEOFFSET
  • New Data Types
    • FILESTREAM Data Type
    • Spatial
    • HIERARCHYID
    • Date and Time New Data Type
      • DATE
      • TIME
      • DATETIME2DATETIMEOFFSET

Note : This question was asked by one of the training attendees. He wanted to have a summary of all the new TSQL enhancement of 2008 at one place. This post is dedicated to that training attendees.


Tags : T-SQL Enhancements done in SQL Server 2008, sql server 2008 tsql enhancements,what is new in sql server 2008 for developer,SQL Server 2008’s new statements extend the T-SQL feature set,SQL Server 2008’s new statements ,

 

EOF - What are T-SQL Enhancements done in SQL Server 2008, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000

Leave a Reply

Your email address will not be published. Required fields are marked *


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.