Code:
ALTER trigger [dbo].[PrestigePoints] ON [PRESTIGE].[dbo].[*Prestige] After UPDATE AS DECLARE [MENTION=339086]Reason[/MENTION] varchar(max) Select [MENTION=339086]Reason[/MENTION]= COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS --update PRESTIGE.dbo.[*Prestige] set [JOB|Death]=[JOB|Death]+1 where [MENTION=643446]killed[/MENTION]Name=CharName DECLARE [MENTION=395373]Chari[/MENTION]D int Select [MENTION=395373]Chari[/MENTION]D=CharID from PRESTIGE.dbo.[*Prestige] DECLARE [MENTION=505066]point[/MENTION] int Select [MENTION=505066]point[/MENTION]=Points from PRESTIGE.dbo.[LIST|PrestigePoints] Where Reason [MENTION=339086]Reason[/MENTION] BEGIN EXEC SRO_VT_ACCOUNT.CGI.CGI_PrestigePoints [MENTION=395373]Chari[/MENTION]D [MENTION=505066]point[/MENTION] END
I'd like to Select @[Only registered and activated users can see links. Click Here To Register...] >> The column name which is updated
but using that >> Select @[Only registered and activated users can see links. Click Here To Register...]= COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS .. doesn't do the job ?
