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?
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Sukesh MarlaPosted Aug 24, 2012, 6:15 AM
Use
following query for updating SqlesHistoryUPDATE
SalesorderSET
rate = 'NewValue'OUTPUT
Deleted.ID, Deleted.rate INTO SalesorderHistoryIn
case changing update query is not possible create trigger and use following queryInsert
into SalesorderHistoryselect
Deleted.ID, Deleted.rate from DeletedCheck
this is correct answer if it helped