Hi team
How to know which column is updated in table without trigger
I have a condition in my SP.
if (ID !=0) then proceed for Update.
else if (ID ==0) then proceed for Insert.
I want to know which filed is get updated from table without trigger.
My table structure as below.
EMPID ,EMPNAME,DESIGNATION,LOCATION,GENDER,AGE
on Update I have written query as
update emptable set EMPNAME=@EMPNAME,DESIGNATION=@DESIGNATION,LOCATION=@LOCATION,GENDER=@GENDER,AGE=@AGE where EMPID=@EMPID
in above query i want to check the which column data is updated.
Like existing value of Gende='Male' and after updation 'FEMALE'
Then get know Gender column is updated.