Diffrences between sql server 2000 vs 2005

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

Why I am getting this error when renaming a database in ms sql server?

0 Answers  


What is the command to change the recovery model?

0 Answers  


How do you manipulate data?

0 Answers  


Explain “not null constraint” in sql server?

0 Answers  


What is the new security features added in sql server 2016? : sql server security

0 Answers  






What is change tracking in sql server?

0 Answers  


What is data integrity? Explain constraints?

1 Answers   Thinksoft,


How do I uninstall sql server 2014?

0 Answers  


Difference between primary key and clustered index?

0 Answers  


What is the difference between clustered and a non-clustered index?

0 Answers   NA,


What is the osql utility?

0 Answers  


what is bit datatype? : Sql server database administration

0 Answers  


Categories