How to cahnge the inserted value in the trigger

jagguhandle · Mar 21, 2004

hi,
I want to change the inserted value in the trigger with notifying the user.
i cant update the value in the INSERTED table as this ia logical table.

Any boody please help.

swampBoogie · Mar 21, 2004

You have to update the table on which the trigger is based

Code:

update trigggerTable
set c = <newValue>
where primaryKeyColumn in 
    (select primarykeyColumn 
       from inserted)

What do you mean by: with notifying the user?

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

How to cahnge the inserted value in the trigger

jagguhandle

Programmer

swampBoogie

Programmer

Similar threads

Part and Inventory Search

Sponsor