quote:

---

Originally posted by visakh16

as told , you can use colums_updated to check which all columns were updated and use catalog view information_schema.columns to get column names

---

quote:

---

Originally posted by webfred

to add insult to injury:
I would do 49 IF-statements and would not believe to updated() because the update could happen with the same value...
I would compare inserted vs. deleted for every column.

---

ALTER trigger [dbo].[tr_trigtest] 
	on [dbo].[patient] 
	for update
as
declare @bit int ,
	@field int ,
	@char int,
	@oldVal varchar(100),
	@newVal varchar(100)

select @field = 0
while @field < (select max(colid) 
	from syscolumns 
	where id = (select id from sysobjects where name = 'patient'))
begin
	select @field = @field + 1
	select @bit = (@field - 1 )% 8 + 1
	select @bit = power(2,@bit - 1)
	select @char = ((@field - 1) / 8) + 1
	--select @char, @field, @bit  -- debug code to check the bits that are tested.
	if substring(COLUMNS_UPDATED(),@char, 1) & @bit > 0
		select @field, name as ColumnName from syscolumns where colid = @field 
			and id = (select id from sysobjects where name = 'patient')
		
end