Question of the Day

Determining the Updated Columns

I am creating a trigger in SQL Server 2022 and want to detect a change in a table. Here is my table DDL:

CREATE TABLE CustomerLarge (
 CustomerID INT NOT NULL IDENTITY(1,1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName VARCHAR(40)
 , Address VARCHAR(20)
 , Address2 VARCHAR(20)
 , City VARCHAR(20)
 , CountryCode CHAR(3)
 , Postal VARCHAR(20)
 , creditlimit INT
 , discount numeric(4,2)
 , lastorderdate DATETIME
 , lastorderamount NUMERIC(10,2)
 , lastordercontact VARCHAR(20)
 , created DATETIME
 , modified DATETIME
 , modifiedby VARCHAR(20)
 , statusid INT
 , active BIT
 , customersize INT
 , primarysalesid INT)
 GO

If I want to detect that the creditlimit was updated, what IF statements should I use?

See possible answers