There is no special statement you can run that will tell you exactly which columns has been update, but if you're trying to actually do something as a result of these changes, then best to write a trigger:
CREATE TRIGGER trToCatchUpdate
FOR UPDATE AS
IF UPDATE(c1) OR UPDATE(c2)
INSERT tblChanges (Oldc1, Newc1, Oldc2, Newc2)
SELECT d.c1, i.c1, d.c2, i.c2
FROM inserted i
INNER JOIN deleted d
ON i.id = d.id
WHERE d.c1<> i.c1
OR d.c2 <> i.c2
Of course you want to do more than in this trigger, but this is an example to demonstrate a simple way by which you can achieve what you really want.
Hope somehow this will help you.
Thanks,Jitendrasoft09, if this helps please login to Mark As Answer. | Alert Moderator