By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE T
(
A int,
B int,
C int,
D int
);
CREATE TRIGGER T_Update ON T FOR UPDATE
AS
DECLARE @colId int =
POWER(2, COLUMNPROPERTY(OBJECT_ID('dbo.T'), 'C', 'ColumnID')-1);
--PRINT COLUMNS_UPDATED();
--PRINT @colId;
--PRINT CAST(@colId as binary(1));
IF COLUMNS_UPDATED() & @colId > 0
PRINT 'C AND ';
IF COLUMNS_UPDATED() & ~@colId = 0
PRINT 'NO '
PRINT 'OTHER COLUMNS'
INSERT INTO T (A,B,C,D) VALUES (0,0,0,0)
1 rows affected
UPDATE T SET A = 1
OTHER COLUMNS
1 rows affected
UPDATE T SET B = 2
OTHER COLUMNS
1 rows affected
UPDATE T SET C = 3
C AND
NO
OTHER COLUMNS
1 rows affected
UPDATE T SET D = 4
OTHER COLUMNS
1 rows affected
UPDATE T SET A = 1, B = 2
OTHER COLUMNS
1 rows affected
UPDATE T SET A = 1, B = 2, C = 3
C AND
OTHER COLUMNS
1 rows affected
UPDATE T SET A = 1, B = 2, C = 3, D = 4
C AND
OTHER COLUMNS
1 rows affected
UPDATE T SET B = 2, C = 3, D = 4
C AND
OTHER COLUMNS
1 rows affected
UPDATE T SET C = 3, D = 4
C AND
OTHER COLUMNS
1 rows affected