Write a Trigger for update a column in sql server
I have 102 sp which modified(insert) a particuler table , but I add A new column DurationInMinutes(bigint) in that table. and these column is updated according Status means it hold timestamps(difference) between two status for example---
new record inserttime is(in first status) 11:30 for a work_orderid
and second status just like work in progress time is 11:46 for above work_orderid
then this column hold value in First Status time is bydefault =0
and in second statust this column hold value is =16 , according to work_orderid
So without changes sp , I want to write a trigger for update those column(DurationInMinutes).
Please give me a sample of trigger for do this type of work..........