question

Maharajan avatar image
Maharajan asked

DIFFERENCE OF DELETE AND TRUNCATE

I NEED DIFFERENCE OF DELETE AND TRUNCATE WITH EXAMPLE
deletetruncatetruncatedexample
1 comment
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Interview question? If you don't know the answer, the best answer is "I don't know."
0 Likes 0 ·

1 Answer

·
nidheesh.r.pillai avatar image
nidheesh.r.pillai answered
Hi there, Here are some links to help you. Read them and if you dont understand a particular context, please do ask. http://beginner-sql-tutorial.com/sql-delete-statement.htm http://www.sqlserver-training.com/list-10-difference-between-truncate-delete-statement-in-sql-server/- http://www.sql-server-performance.com/2006/delete-truncate-difference/ http://codebetter.com/raymondlewallen/2005/05/09/the-difference-in-truncate-and-delete-in-sql-server/ http://stackoverflow.com/questions/139630/whats-the-difference-between-truncate-and-delete-in-sql
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.