I am having trouble with a problem in SQL. I am supposed to apply a trigger code

Question

I am having trouble with a problem in SQL. I am supposed to apply a trigger code to every column in a Person.Person table. When I put the code in SQL it is full of errors. The code is

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

The table names are PersonType nchar(2), FirstName nvarchar(50) LastName nvarchar(50). How do I write the code to get rid of the errors?

Explanation / Answer

CREATE TRIGGER [TRIGGER_ALTER_COUNT] ON [dbo].[tblTriggerExample]

FOR INSERT, UPDATE

AS

BEGIN

DECLARE @Var INT

SELECT @Var = COUNT(*) FROM INSERTED

UPDATE [dbo].[tblTriggerExample] SET AlterCount = AlterCount + Var  

,LastUpdate = GETDATE()

WHERE TransactionID = @TransID

SELECT @Var = COUNT(*) FROM UPDATED WHERE SystemNAme = 'Var'

UPDATE [dbo].[tblTriggerExample] SET AlterCount = AlterCount + @Var

,LastUpdate = GETDATE()

WHERE TransactionID = @TransID

END

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.