SQL query

Aug 24 2012 5:10 AM

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?