I have a Staff Table with a DateTime field "UpdateTime",
Can I write a table Update Trigger to make a copy of non-update record with out "UpdateTime" in Same Table!?
i.e.
if user change the staff information, the staff table will KEEP the original record to add a New Record with UPdated information!
Then, the staff table have another field called "CurUse" Logic will turn to True for right the last updated record!
Currently, I can use update trigger to copy the record into new table
but it is too waste as only carry one more field on "UpdateTime"!!
The weak wait for chance, The strong bid for chance,
The clever notch up chance, but The merciful give you chance.