Answer Posted / padmapriya

1.sql server 2005 include interprise manger and query
analyser together in same window we can open many window
tabs in same place but in 2000 it is in different.
2. sql server 2005 support more new datatype like xml
3. we can make more database 2(paw(20))-1 in 2005 in compare
to 2000 where not possible so much database
4. in storeprocedure we can write try catch statemenet in
2005 not in 2000

What does dml stand for?

948

---

explain different types of joins? : Sql server database administration

985

---

What are differences in between sql server 2012 and sql server 2016?

1049

---

Mention the uses of stored procedures.

972

---

What guidelines should be followed to help minimize deadlocks?

943

---

How to provide values to stored procedure parameters in ms sql server?

1037

---

What is the return type of executeupdate ()?

906

---

User wants only to display only pdf as export option in report manager. How to achieve this?

262

---

What is the purpose of the master database?

1129

---

Define magic tables in sql server?

1068

---

You want to check the syntax of a complicated update sql statement without executing it. What command should you use?

990

---

How to change server name in sql server?

1184

---

What are the properties of sub-query?

1074

---

Can I save my report as html, excel or word? : sql server management studio

955

---

Do you know what is a linked server in sql server?

1025

---