The purpose of this assignment is to alter and apply the trigger code to the Person.Person table in the Adventure Works database.
First, amend the trigger code (below) to fire correctly on the “Person.Person” table. Next, apply the trigger code provided below to the “Person.Person” table to track the number of modifications of data for the table. Check that the trigger worked by updating 4 records in the “Person.Person” table.
· Add the “Title” ‘Mr.’ to ‘Ken J Sánchez’
· Add the “MiddleName” ‘Timothy’ to ‘Michael Raheem’
· Add the “Title” ‘Ms.’ and change the “MiddleName” to ‘Heather’ for ‘Samantha H Smith’
· Add the “Title” ‘Mrs.’ and change the “LastName” to ‘Thompson’ for ‘Lori K Penor’
Compile the Word document with the alter trigger code, result table, and a screenshot of the fired trigger results and submit to your instructor.
I’m having trouble on how to set this query up, I get error codes a lot. Can someone help explain how a trigger works with this code?
