Breaking News: Grepper is joining You.com. Read the official announcement!

sql update trigger check if value has changed

Metacennftric Shakib answered on July 27, 2022 Popularity 5/10 Helpfulness 1/10

answer sql update trigger check if value has changed

sql update trigger check if value has changed

Comment

CREATE TRIGGER [dbo].[CustomersUpdateTrigger]
ON [dbo].[Customers]
AFTER UPDATE
AS
  BEGIN
      IF UPDATE(LastName)
        PRINT 'UPDATE(LastName)'

      IF ( COLUMNS_UPDATED () & 1 = 1 )
        PRINT 'COLUMNS_UPDATED ( )  & 1'

      IF EXISTS(SELECT LastName
                FROM   inserted)
        PRINT 'EXISTS(SELECT LastName FROM inserted)'
  END

Popularity 5/10 Helpfulness 1/10 Language sql

Source: Grepper

Tags: sql sql-update

Link to this answer
Share Copy Link

Contributed on Jul 27 2022

Metacennftric Shakib

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

sql update trigger check if value has changed

Contents

More Related Answers

sql update trigger check if value has changed

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.