Create Trigger Trig_notic_uion notic for insert, UpdateasUpdate Notic Set Memo = MEMO '' WHERE ID IN (SELECT ID FROM INSERTED) GO / * TRIG_NOTIC_UI Trigger Name Custom Notic Required Table Name MEMO Update Field ID is the primary key * /