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 are the events recorded in a transaction log?

1000

What are the essential components of sql server service broker?

1018

Explain following error properties?

1017

Which are the important points to note when multilanguage data is stored in a table?

996

How important do you consider cursors or while loops for a transactional database?

965

Write an sql query for deleting duplicate rows?

995

What are policy management terms?

985

Explain the difference between HTTP and HTTPS in database?

1036

How to create a ddl trigger using "create trigger" statements?

1131

What is optimization and its types?

978

Explain the commands in sql server?

1038

How to get a list of columns in a view using "sys.columns" in ms sql server?

994

What is a join in sql?

1092

What is dirty read?

1080

Explain tables in SQL Azure?

120