Difference between Truncate and Delete command in SQL - Interview Questions with Example 1. truncate...

Please Visit: http://ift.tt/1ajReyV

Difference between Truncate and Delete command in SQL - Interview Questions with Example

1. truncate is fast delete is slow.

2. truncate doesn't do logging delete logs on per row basis.

3. rollback is possible with delete not with truncate until specifically supported by vendor.

4. truncate doesn't fire trigger, delete does.

5. Don't delete, truncate it when it comes to purge tables.

6. truncate reset identity column in table if any, delete doesn't.

7. truncate is DDL while delete is DML (use this when you are writing exam)

8. truncate doesn't support where clause, delete does.

http://ift.tt/1qPijEO

http://ift.tt/1rgbv5y

Difference between Truncate and Delete command in SQL - Interview Questions with Example

from Public RSS-Feed of Jeffery yuan. Created with the PIXELMECHANICS 'GPlusRSS-Webtool' at http://gplusrss.com http://ift.tt/1qPihNd

via LifeLong Community