how to update,delete record from multiple table having primary key and foriegn key constrain?

Hi,

It would help if we knew what fields you have available on update or delete, but here I will assume you have al the fields in the user table.

For Update

Create Procedure ProcUpdateUser()
@logid int,
@name varchar(50)

as 
begin
update user set name=@name where log_id=@logid
update login set username=@name where log_id=@logid

end

For Delete

Create Procedure ProcDeleteUser

@name varchar(50)

as
begin
delete user where name=@name
delete login where username=@name

end

You will need to change the parameters according to your needs but hope this helps.