Skill 2.3 Create triggers and user-defined functions
In this final skill of the chapter, we cover two very different, and somewhat lesser-used features of Transact-SQL, with very little overlap between them.
First we look at TRIGGER objects, which in itself is a very large topic, particularly because there are three different types of triggers that you can work with, but equally because they are quite a bit more complex than STORED PROCEDURE objects. You use them to react to some event, either a DML operation such as an INSERT, UPDATE or DELETE statement execution; someone changing a setting or object on the server; or even someone logging into a server.
Then we cover the details of User-Defined Functions (or UDFs) that allow you to create ...
Get Exam Ref 70-762 Developing SQL Databases now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
