Update database triggers

Copy coupon table Hook use hshdbnew SELECT * to Tempexistcoupon from Discountactivitypager WHERE 1=2

--update trigger Create TRIGGER tri_update   on  discountactivitypager            after update  as begin  if Update (Udsateid) and (select top 1 udsateid  from Disc Ountactivitypager WHERE udid= (select top 1 UDID from Deleted) = ' 2 ' INSERT into [tempexistcoupon] (UDID,USERID,BID,DID,UDN O,udcode,uddatetime,memorandum,discontdetail,busname,udsateid,checkdate,checkintegralcount,ratings,starlevel, CHECKCONTENTSTR,BEID,USERCOUNT,BATNO) SELECT [udid],[userid],[bid],[did],[udno],[udcode],[uddatetime],[ memorandum],[discontdetail],[busname],[udsateid],[checkdate],[checkintegralcount],[ratings],[starlevel],[ Checkcontentstr],[beid],[usercount],[batno] from discountactivitypager  where udid= (select top 1 UDID from Deleted ) End