what is advantages in sql 2005 over sql 2000?

Answer Posted / ashis

Sql server 2005 have some new data types like varchar
(max),xml. Sql server 2005 have SSIS instead of dts in sql
server 2000. SSRS with adhoc reporting. Some sys command
are changed like sys.objects, sys.columns.

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the requirements for sql server 2016?

539


What is the meaning of resultset type_scroll_insensitive?

565


Can we do dml on views?

555


How to test a dml trigger in ms sql server?

583


After removing a table from database, what other related objects have to be dropped explicitly?

557






What is a primary key?

543


Do you know the different ddl commands in sql?

593


What is the difference between set and select?

581


Why SQL Agent is used?

602


What is clr ddl trigger?

552


Why we need sql server?

561


What is nonclustered index with included columns ?

554


What is always encrypted?

520


can we have a nested transaction? : Sql server database administration

507


What is coalesce and check constraint in sql server?

547