Difference between truncate and delete

Posted Date: 14 Nov 2008	Resource Type: Definitions	Category: General
Author: Bunty	Member Level: Diamond
Rating:	Points: 5

Hi,

The TRUNCATE and DELETE statement are identical in functinally. The differences are as follows,

1>TRUNCATE statement works faster than DELETE statement.

2>TRUNCATE statement will not fire trigger whereas DELETE statement will fire trigger.

3>TRUNCATE statement does not have a WHERE clause whereas IN DELETE statement WHERE clause is optional.

Thanks and Regards
S.S.Bajoria

Responses

No responses found. Be the first to respond and make money from revenue sharing program.

Feedbacks

Popular Tags

What are tags ?

Search Tags

SQL Server .

Post Feedback

This is a strictly moderated forum. Only approved messages will appear in the site. Please use 'Spell Check' in Google toolbar before you submit.
You must Sign In to post a response.

	Next Resource: What is pipelining?
	Previous Resource: Control State, Partial Class, Iterators, Nullable – At a glance
	Return to Discussion Resource Index
	Post New Resource
	Category: General

Post resources and earn money!

More Resources