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.