Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

Share this Page URL
Help

Chapter 11. TRIGGERS > NESTED TRIGGERS - Pg. 199

n esteD t riggers 199 RAISERROR ("Invalid pub_id inserted", 16, 1) END RETURN BEGIN TRAN add_titles INSERT titles (title_id, pub_id, title) VALUES (`BU1234', `0736', `Tuning SQL Server') IF @@error = 50000 BEGIN ROLLBACK TRAN add_titles RETURN END INSERT titles (title_id, pub_id, title) VALUES (`BU1235', `abcd', `Tuning SQL Server') IF @@error = 50000 BEGIN ROLLBACK TRAN add_titles