Click to See Complete Forum and Search --> : update trigger


December 27th, 1999, 01:19 AM
update trigger written as follows is not working and we are not able to update the record because of the foreign key constraints violation.pls help and
do send the reply at progsoft@ndf.vsnl.net.in

Create Trigger <trigname> on <tablename>
for update
as

declare @key_after nvarchar,@key_before nvarchar

if UPDATE( <fieldname> )

begin

Select @key_before = <fieldname> from deleted
Select @key_after = <fieldname> from inserted

Update <fk_table_name>
set <fieldname> = @key_after
where <fieldname> = @key_before

end