Sql : 触发器 update

ALTER trigger [update_Tts_Hotel_Master]
on [dbo].[Tts_Hotel_Name]
after update --insert, update, delete
as
--列级触发器：是否更新了酒店名称    
if (update(H_Name))   
begin 
update Tts_Hotel_Master
set Tts_Hotel_Master.Hm_hName =inserted.H_Name
from Tts_Hotel_Master,inserted
where Tts_Hotel_Master.Hm_Hid=Inserted.H_ID
end

 

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 h2 where h1.Tts_OrderID=h2.Tts_OrderID
  end