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"!!