1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

difference between sql server2000 and sql server2005

Question Posted / singhvijay82


difference between sql server2000 and sql server2005 ..

Answer / rajkumar

1.SQL Server 2005 has better tool enhancements like SQL
Server Management Studio.
2.Developers can write Native .NET Stored Procedures and
deploy them to SQL Server 2005.
3.It has more Enhancements in the areas of DBA, Developer
Productivity with .NET

For More details..Verify these links..
http://wiki.answers.com/Q/Diff_between_sql_server_2000_and_s
ql_server_2005
http://techinterviewquestion.blogspot.com/2008/06/some-
difference-between-sql-server-2000.html

Is This Answer Correct ?    6 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is sql server english query?

0 Answers  

What is recompile sql server?

0 Answers  

What is scheduled job and how to create it?

0 Answers  

I have a website that allows customers to browse and place orders for certain products. I have 2 tables; Customers and Orders. The Customers table holds the customer records and the Orders table holds the orders placed by the customer. Both tables are tied based on the field Cust_ID. Example of the data is shown below: Cust_ID Cust_Name Cust_ID Product Amount Order_Date 1001 John Tan 1001 P-5211 $120.00 2/13/2006 1002 Michael Wong 1001 K-1428 $88.90 1/11/2006 1003 Mary Cheong 1003 C-0923 $82.50 1/27/2006 1004 Ahmad Suffian 1003 K-1428 $88.90 2/2/2006 Write a single SQL statement that extracts all purchase records with the following criteria: 1. Customer names starting with “M” only. 2. Orders placed within the current month only. 3. Amount does not exceed $100.00 The list must be sorted by order date with the latest order showing on top.

3 Answers   Techno Solutions,

What are the character string functions supported by sql server 2005?

0 Answers  




How extra digits are handled with numeric data type literals?

0 Answers  

how to select a field with firstletter as capital and remaining are small letters

11 Answers  

What is the difference between views and stored procedures? Can we have input parameters for views?

6 Answers  

Does a server store data?

0 Answers  

What is star, snowflake and star flake schema? : sql server analysis services, ssas

0 Answers  

what changed between the previous version of sql server and the current version? : Sql server database administration

0 Answers  

Explain for xml explicit mode?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories