Difference between Truncate and Delete

[r aa j]

hi all.... what is the difference between truncate and Delete...I have used following code but both are rollback....if anybody knows please reply me.. BEGIN TRANSACTION; delete from one rollback TRANSACTION BEGIN TRANSACTION; Truncate table one rollback TRANSACTION Thanks

Raaj

[Blue_Boy]

Difference between Truncate and Delete[^]

---

I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post.