Given a Table with a column col1 like this:
create table MyTest ( col1 int NULL, col2 decimal(7, 2) NULL ); insert into MyTest values ( 1, 1.1);
Is there a way for a trigger for update to decide which of the following update statements was executed ?
update MyTest set col1 = 3;
update MyTest set col1 = 3, col2 = 1.1;