create TRIGGER CustomerUpdateTrigger ON NOMINATEDUSER FOR UPDATEAS declare @IDCHANNELUSER varchar(100); declare @NOMINATEDUSERID varchar(100); declare @NOMINATEDUSERNAME varchar(100); declare @PHONENUMBER varchar(100); declare @UPDATEDBY varchar(100); declare @CUSTID varchar(100); declare @LASTUPDATED datetime; select @IDCHANNELUSER=i.IDCHANNELUSER from inserted i; select @NOMINATEDUSERID=i.NOMINATEDUSERID from inserted i; select @NOMINATEDUSERNAME=i.NOMINATEDUSERNAME from inserted i; select @PHONENUMBER=i.PHONENUMBER from inserted i; select @UPDATEDBY=i.UPDATEDBY from inserted i; select @LASTUPDATED=i.LASTUPDATED from inserted i; select @CUSTID=i.CUSTID from inserted i; update NOMINATEDUSER set IDCHANNELUSER=@IDCHANNELUSER,NOMINATEDUSERID=@NOMINATEDUSERID,NOMINATEDUSERNAME=@NOMINATEDUSERNAME, PHONENUMBER=@PHONENUMBER,LASTUPDATED=@LASTUPDATED,UPDATEDBY=@UPDATEDBY WHERE CUSTID= @CUSTID