I need to write a SQL trigger for a table. I need the trigger to look at the value in FIELD A and copy that value and move that value to FIELD B. I then need it to put a zero in FIELD A. So, if FIELD A started with a value of 100 my end result would be a value of 0 in FIELD A and a value of 100 in FIELD B. I need help with the correct syntax to make this happen.
8/22/2022 - Mon
Your help has saved me hundreds of hours of internet surfing.