Row Constructors Output Clause Compound Operators Inline Variable

What are all new concepts in SQL Server 2008? That is
Exactly Difference between 2005 to 2008

Question Posted / jigar

Answer Posted / jigar

Row Constructors

Output Clause

Compound Operators

Inline Variable Assignment

Grouping Sets

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the concept of recursive stored procedure.

879

What is transaction server implicit?

947

Difference between Inner vs outer joins?

894

What is named query? : sql server analysis services, ssas

908

What is sparse columns of sql server 2008?

994

what is a join and explain different types of joins? : Sql server database administration

911

Which operator do you use to return all of the rows from one query except rows are returned in a second query?

944

How to list all objects in a given schema?

985

What are recommended options to be used while using db mirroring? : sql server database administration

1069

whats new about truncate in sql server 2008?

2440

What is collation sensitivity?

985

What are Row versions of DataRow?

974

Can I disable or restrict ssrs export formats (rendering formats)?

140

What is difference between getdate and sysdatetime in sql server 2008?

999

What is a virtual table in sql?

943