Currently browsing

December 5, 2012

COMMIT and ROLLBACK TRANSACTION in Triggers

COMMIT and ROLLBACK TRANSACTION in Triggers One of my friends asks me to write an article related to COMMIT and ROLLBACK TRANSACTION in Triggers. After reading one of my previous article DELETE restriction of VIEWS http://sqlknowledgebank.blogspot.in/2012/06/delete-restrictions-of-views.html Where I am using a ROLLBACK TRAN in a trigger (INSTEAD OF DELETE trigger), …