Trigger...

[-Prestige..]

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 @ >> The column name which is updated


but using that >> Select @= COLUMN_NAME from INFORMATION_SCHEMA.COLUMNS .. doesn't do the job ?

[B1Q]

set @ = (select Reason from inserted)

[-Prestige..]

Originally Posted by B1QB0SS :3

set @ = (select Reason from inserted)

Well the inserted line is like >>
Update xxxx set vv=vv+1 where zz=zz

how can i capture that "vv" ?


Edit >> That "vv" is a column name? .. so ..
Set @ = COLUMN_NAMEorsmth from inserted .
is not working.. i tried everything ...
am not that expert .. but i can work around things ..

[B1Q]

dude wtf are you talking about!
it's like this

select @omk = mycoluimn from inserted

[-Prestige..]

Originally Posted by B1QB0SS :3

dude wtf are you talking about!
it's like this

select @omk = mycoluimn from inserted

what is the **** statement ? ?

---------------------------------------------------------------------------------------------
in other words, how can i capture the name of column which is being updated?

[​Exo]

Originally Posted by -Prestige..

what is the **** statement ? ?

---------------------------------------------------------------------------------------------
in other words, how can i capture the name of column which is being updated?

Okay I am gonna assume that you have pretty stupid structure for a very simply operation.

Please post a picture of the table.

[B1Q]

oh... ok check
UPDATE(COLUMN_NAME) it returns boolean
true: if the column name specified was updated

it will return TRUE for all columns on insert hh

USAGE:
IF (UPDATE(MYCOLUMN))
BEGIN
-- MYCOLUMN WAS UPDATED
END