creating stored procedure

create procedure procstatus
(
	@username varchar(25),
	@reqname varchar(25)
)
as
begin
	update friendrequest set status='accept' where acceptor=@username and requestor=@reqname
	declare @status varchar(25);
	set @status=(select status from friendrequest where (acceptor=@username and requestor=@reqname))
	if(@status='accept')
	begin
		insert into login4 values(@reqname,@username)
	end
end