Daily Archives: 10/27/2014

---

Sql Inteview Question #10 : What are catalog views?

This entry was posted in Sql Server Interview Questions Sql Server tutorials and tagged catalog server sql views on 10/27/2014 by Blog Admin.

Sql Inteview Question #10  What are catalog views? Solution

---

What is the difference between the DELETE and TRUNCATE

This entry was posted in Sql Server 2005 Sql Server 2008 Sql Server DBA Sql Server DEV Sql Server tutorials and tagged query row server sql view on 10/27/2014 by Blog Admin.

Solution The delete command removes the rows from a table on the basis of the condition that we provide a WHERE clause. Truncate will actually remove all of the rows from a table, and there will be no data in the table after we run the truncate command.

---