Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 dmvs? : sql server database administration

1115


What is pessimistic concurrency?

1021


What are the types of normalization?

1071


Using the customer, and order table in northwind database, please write a query to produce xml?

1110


What do you understand by recursive stored procedures?

1040


What is difference between temp table and cte?

1068


What are different types of subquery?

1302


what is package and it uses and how can u call a package

2065


How to drop an existing schema in ms sql server?

1141


What is stored in the mssqlsystemresource database? : sql server database administration

1076


How many categories of functions based their return modes?

1146


What is tablesample?

1171


How to divide query output into multiple groups with the group by clause in ms sql server?

1084


What are the new scripting capabilities of ssms? : sql server management studio

1114


List out the differences between the clustered index and non-clustered index in sql server?

1046