SQL: trigger update

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