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

How to apply filtering criteria at group level with the having clause in ms sql server?

0 Answers  

---

How to drop an existing stored procedure in ms sql server?

0 Answers  

---

What do you understand by coalesce in sql server?

0 Answers  

---

Where do we use trace frag?

0 Answers  

---

Is it possible to allow NULL values in foreign key? I s it possible to use different constraints for the same column in the table (i.e) (id int NOT NULL,UNIQUEUE)

1 Answers  

---

---

A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

Questions regarding Raiseerror?

1 Answers  

---

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

---

What is 2nf in normalization?

0 Answers  

---

What are cursors? Name four types of cursors and when each one would be applied?

3 Answers   Adea Solutions,

---

What are the two types of concurrency?

4 Answers  

---

How to find Duplicate Records In table?

0 Answers   HCL,

---