In my SQL Server database, I want a new field in my table called something like 'UPDATED'.
I want this to be defaulted to FALSE. If fields x, y or z are set to TRUE then I want the value of UPDATED to be changed to TRUE as well. And then, if x, y and z are ALL changed to FALSE, then the value of UPDATED be set back to FALSE again.
Is this possible? If so, can someone show me how, or point me in the right direction please?
Thanks a lot.
I want this to be defaulted to FALSE. If fields x, y or z are set to TRUE then I want the value of UPDATED to be changed to TRUE as well. And then, if x, y and z are ALL changed to FALSE, then the value of UPDATED be set back to FALSE again.
Is this possible? If so, can someone show me how, or point me in the right direction please?
Thanks a lot.