Need Help Purpose Assignment Alter Apply Trigger Codeapply Trigger Code Provided Column Pe Q34757860

Question

I need help on this,The purpose of this assignment is to alterand apply the trigger code.Apply the trigger code provided below toeach column of the “Person.Person” table to track the number ofmodifications of data for each column in the table.

Trigger Code: CREATE TRIGGER [TRIGGER_ALTER_COUNT] ON[dbo].[tblTriggerExample]

FOR INSERT, UPDATE AS

BEGIN

DECLARE @TransID VARCHAR(36)

SELECT @TransID = TransactionID FROM INSERTED

UPDATE [dbo].[tblTriggerExample] SET AlterCount = AlterCount + 1,

LastUpdate = GETDATE()

WHERE TransactionID = @TransID

END

Expert Answer

Sau forn Gtfven that 8eqin Name) -Foon) intoomation - schema. Roos cohes e table-name-t person, Beain Ser未Advea se x-AdverseTfupdasesamRueName) 8egin Opdare tbusaoRue SET e DaseTfme - CURRENT END END

Sau

Leave a Comment