Follow in Twitter & Facebook

Like in Facebook

Powered By Blogger Widgets

Free Download

FREE Tools

Tuesday, March 27, 2012

Delete and Truncate in sql server 2008

Here we will discuss what is the difference between Delete and Truncate in SQL Server 2008. Normally this is also a very good interview question. You can read an article on Connection Pooling in Asp.Net.

(1)-It can delete all rows or particular row .

(2)-Delete is recorded in log file.

(3)-Data can be restored here.

(4)-Delete willnot reset identity.

(5)-Delete is slower than truncate.

(1)-It can delete only all rows.

(2)-Truncate is not recorded in log file.

(3)-Data cannot be restored.

(4)-Truncate will reset identity.

(5)-Truncate is faster than delete.

Also you can check Asp.Net and SharePoint interview questions and answers.

0 on: "Delete and Truncate in sql server 2008"