Diffrences between sql server 2000 vs 2005

Question Posted / subbu

2 Answers
5018 Views
Thomson Reuters, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Diffrences between sql server 2000 vs 2005..

Answer / naren

New data type XML, Binary
SSIS,SSRS,SSAS

Is This Answer Correct ?

4 Yes

1 No

Diffrences between sql server 2000 vs 2005..

Answer / sakthi

for error handling in 2005 we use try catch, new functions
like pivot and unpivot, datatype nvarchar(max), varchar
(max), char(max) to handle xml in 2005 we have special
datatype caller XML.

Is This Answer Correct ?

3 Yes

0 No

Post New Answer

More SQL Server Interview Questions

What is a schema in ms sql server 2005?

0 Answers

Suggest a method of joining two tables.

0 Answers Ernst Young, Thomson Reuters,

How to include date and time values in sql statements?

0 Answers

What is an indexing technique?

0 Answers

What according to you is the difference between mysql and sql server performance?

0 Answers

How do I clean up sql server transaction log?

0 Answers

i need to know how i display department which has salary > =5000 for the below table Department ----------- salary deptname 1000 a 3000 a 2000 b 3000 b 4000 c 5000 c kindly send the query to thilakvinoth13@gmail.com

6 Answers

What is a transactions?

0 Answers

What is the difference between migration and upgradation in sql server?

0 Answers

Is it possible to call a stored procedure within a stored procedure?

0 Answers

what is bit datatype? : Sql server database administration

0 Answers

What is DAC? what is the use of it?

1 Answers Wipro,

For more SQL Server Interview Questions Click Here