SQL query

Question

I am having tables salesOreder & salesOrderhistory... So if My Rate in SalesOrder is Updated I want to insert whole row into salesOrderHistory with maximum serial No.. How? help me?

Sukesh Marla · Answer

Use following query for updating SqlesHistory UPDATE Salesorder SET rate = 'NewValue' OUTPUT Deleted . ID  Deleted . rate INTO SalesorderHistory In case changing update query is not possible create trigger and use following query Insert into SalesorderHistory select Deleted . ID  Deleted . rate from Deleted Check this is correct answer if it helped