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

Introduction:
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.

Description:
Delete:
(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.

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"