- Course
Triggers and Stored Procedures: A Combined Approach
Want to keep your triggers lean and efficient, whilst centralizing your code? This course will teach you how to use stored procedures to enhance and improve your SQL Server triggers.
Beginner
- Course
Triggers and Stored Procedures: A Combined Approach
Want to keep your triggers lean and efficient, whilst centralizing your code? This course will teach you how to use stored procedures to enhance and improve your SQL Server triggers.
Beginner
Get started today
Access this course and other top-rated tech content with one of our business plans.
Try this course for free
Access this course and other top-rated tech content with one of our individual plans.
This course is included in the libraries shown below:
- Data
What you'll learn
Is your trigger code too long? Do you find yourself replicating code in your triggers? Maybe using stored procedures with triggers is the answer! In this course, Triggers and Stored Procedures: A Combined Approach, you’ll gain the ability to integrate stored procedures with triggers. First, you’ll explore how to pass data from triggers into stored procedures, learning how transactions interact between the two. Next, you’ll discover how to implement audit trails within triggers, using stored procedures to handle the auditing. Finally, you’ll learn how stored procedures can be used within triggers to implement referential integrity. When you’re finished with this course, you’ll have the skills and knowledge of triggers and stored procedures needed to create excellent, efficient triggers integrated with world-class stored procedures.
Triggers and Stored Procedures: A Combined Approach
Beginner
Table of contents
Mike loves to mess around with data and programming problems, the bigger the better. He’s worked with a variety of companies, helping to build and improve systems of all shapes and sizes.