Alter trigger [update_tts_hotel_master] on [DBO]. [tts_1__name] After update -- insert, update, deleteas -- column-Level Trigger: whether the hotel name if (Update (h_name) Begin update tts_1__masterset tts_1__master.hm_hname = inserted is updated. h_namefrom tts_cmd_master, insertedwhere tts_cmd_master.hm_hid = inserted. h_idend
Alter Trigger [ Modify_tts_orderremark ] On [ DBO ] . [ Tts_order_log ] For Insert , Update As Declare @ Row Int Select @ Row = @ Rowcount If @ Row = 0 Return If ( Exists ( Select 1 From Inserted )) Begin Update H1 Set Tts_orderremark = Isnull (H1.tts _ orderremark, '' ) + Convert ( Varchar ( 16 ), Getdate (), 120 ) + ' | ' + Cast (H2.tts _ Username As Nvarchar ( 20 )) + ' | ' + Cast (H2.tts _ orderremark As Nvarchar ( 300 )) + ' ☆ ' From Tts_order_total As H1, inserted As H2Where H1.tts _ orderid = H2.tts _ orderid End