Answer Posted / pavan

Drop will delete all the existing structure. if it applies
to a table, Truncate will delete only the data while
keeping the structure of the table as it is.

What is the difference between lock, block and deadlock? : sql server database administration

990

---

What are the types of user defined functions in sql server?

989

---

What are Row versions of DataRow?

974

---

what are constraints? Explain different types of constraints? : Sql server database administration

919

---

What is raid, and how it can influence database performance?

1008

---

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

900

---

How many database files are there in sql server 2000?what are they?

977

---

How do I edit a stored procedure in sql server?

882

---

 Explain what is sql override for a source taLle in a mapping?

945

---

What is after dml trigger?

954

---

Explain what is dbcc?

962

---

How to use the inserted and deleted pseudo tables?

914

---

What are Spatial data types in SQL Server 2008

963

---

Difference between DELETE and TRUNCATE?

1002

---

what are the three command line utilities and what are their primary functions?

136

---