[Yi fei] update trigger (yi fei's work hour base number triggers this level of manual fee)

When the previous write is triggered

Direct for update

Save the variable...

Update Fields

In fact, this can be triggered for that field.

If Update (field)

Begin

SQL...

End

Write one:

Create trigger [update_currentlabour_fabricatingcost] on [DBO]. [invmb]
For update
As
Declare @ mb001 char (20 ),
@ Mb096 decimal (7,4)

Begin transaction
Set nocount on

If Update (mb096)
Begin
Select @ mb001 = mb001, @ mb096 = mb096 from inserted where mb025 = 'M'
Update invmb set
Mb061 = @ mb096 * 0.16, mb062 = @ mb096 * 0.16*0.7 where
Mb001 = @ mb001
End

Set nocount off
Commit transaction

Although it is a simple change, it is at least reasonable and efficient, especially when the changes are frequent.

Tieguanyin-factory direct sales