Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
8
Reply
Difference b/w Truncate and Delete
DeepAk BhAtt
Jul 1 2015 4:09 AM
748
Reply
I READ MANY ARTICLES FROM WEB WHICH POINT
ING
OUT MANY DIFFERENCE ...
SOME OF THEM ARE FINE .. BUT I GOT CONFUSED DIFF W.R.T.
ROLLBACK
I THINK THEY EXPLAIN A WRONG DIFFERENCE "
DELETE IS ROLLBACK BUT TRUNCAT IS NOT
"
BUT WHEN I DID ACTUAL IMPLEMENTATION IT'S GIVE ME UNEXPECTED OUTPUT ............ BOTH TRUNCAT AND DELETE GETS ROLLBACK..
PLEASE ANY ONE HAVE THE SOME EXPLANATION ABOUT THIS QUERY .........
REPLY ME SOON .. THANK YOU
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
8
)
Next Recommended Forum
How to prevent recursion of update trigger on the same table
Formating Excel Sheet While creating from BCP in Sql server?