C# Tutorials and offshore development in India

Prizes & Awards

My Profile

AdSense Revenue

Active Members
Today

Last 7 Days

UmaShankar (1337)
ANIL PANDEY (799)
Pradeep Y (548)

more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !

Rolling back Delete and Truncate commands

Posted Date: 20 Jun 2008 Resource Type: Code Snippets Category: SQL

Posted By: Kapil Dhawan Member Level: Gold
Rating:

Points: 5

I have listened to many guys say that truncated tables can not be rollback-ed.
So i was confused and tried this at home :


begin transaction
delete from tab_Order
rollback

The above query got rolled back

Similarly, look at the next query.


begin transaction
truncate table tab_Order
rollback

Above query also rolled back.

There are few points that you can learn from this:

we can not truncate table that has foreign key constraints
truncate reset any identity column to default seed value.

Responses

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

Feedbacks

Popular Tags

What are tags ?

Search Tags

Rollback truncate delete commands . Rollback truncate command . Rollback Delete command . Rollback commands .

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: String Concatenation in Sql Server
	Previous Resource: INSERT and UPDATE using Triggers in SQL Server
	Return to Discussion Resource Index
	Post New Resource
	Category: SQL

Post resources and earn money!

Related Resources

dotNet Slackers BizTalk Adaptors Web Design

conference call