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

What is the difference function and stored procedure?

1033

You want to implement the many-to-many relationship while designing tables. How would you do it?

978

What are the disadvantages of using the stored procedures?

1079

Explain the difference between function and stored procedure?

926

What are the characteristics of modern DBMS?

1072

What is the purpose of data source?

1018

What is perspective, have you ever created perspective? : sql server analysis services, ssas

899

What are extended events in sql server?

937

Do you know query execution plan?

1147

How to encrypt data between dialogs?

1077

Can we run Reporting Services with SQL Server express edition, which is a free version of SQL Server?

118

Explain the concepts and capabilities of sql server?

956

What are subqueries in sql server? Explain its properties.

996

How do you identify a foreign key?

1009

How can I get data from a database on another server?

972