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.
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"