.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Melody Anderson

Home >> Forum >> Sql Server >> Post New QuestionBookmark and Share Subscribe to Forum

What are the new features that we have in Sql Server 2008?

Posted By: Deco     Posted Date: September 22, 2010    Points:2   Category :Sql Server
Please help me to get the complete list of new features in Sql Server 2008...

Author: Syed Shakeer Hussain             
Posted Date: September 22, 2010     Points: 5   

Hi Alwyn,

Compound Operators
SQL Server 2008 introduces the Compound Operators which execute some operation, such as + (addition), - (subtraction), * (multiplication) and / (division), and set an original value to the result of the operation.

Multiple Value Inserts Within a Single INSERT Statement
One of the new programmability enhancements in the Database Engine introduced in SQL Server 2008 for Transact-SQL is the row constructor which consists of a single VALUES clause with multiple value lists enclosed in parentheses and separated by a comma. With the row constructor, you can now insert multiple values using a

MERGE Statement
One of the common tasks in database management is the maintenance of lookup tables. Maintenance of these look-up tables are usually done using stored procedures where the normal task is to add the new record if it does not exist or update the existing record if it already exists based on the identified primary key of the table. SQL Server 2008 introduces a new statement called MERGE statement which combines these functionalities into just a single statement. The MERGE statement performs an INSERT, UPDATE or DELETE operation on a target table based on the results of a join with source table.

Table-Valued Parameters
SQL Server 2008 introduces a new parameter type called the table-valued parameters. With the table-valued parameters, which are declared by using user-defined table types, you can now send multiple rows of data to a function or stored procedure without creating a temporary table or many parameters.

Post Reply

You must Sign In To post reply
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend