Okay.. Now tel me if any other alternative other than dis two approaches..

Not on update cascade & trigger.

Is there any other method???????????????

create TRIGGER parent_trigger ON parenttable

FOR update AS

begin

declare @id int

DECLARE @name VARCHAR(10)

declare @id1 int

select @id=id from inserted

select @name=name from inserted

select @id1=id from deleted

update childtable1 set id=@id,name=@name where id=@id1

update childtable2 set...

Not only changing the primary key column, we want to change remaining columns in the record..

By using on update cascade we can update the primary & foreign key column

through...