How to Create Stored Procedure in Sql Database

Stored Procedure by Youtube shiva concept  solution

CREATE PROCEDURE [dbo].[sp_insert_branch]( @bid int = 0, @bname varchar(50))

AS

begin

insert into branch(BranchId, BranchName) values(@bid, @bname);

end

-----------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[sp_update_branch]( @bid int, @bname varchar(50))

AS

begin

update branch set BranchName = @bname where BranchId = @bid;

end

--------------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[sp_delete_branch]( @bid int, @bname varchar(50))

AS

begin

delete from branch  where BranchId = @bid;

end

---------------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[sp_select_branch]

AS

begin

select * from branch;

end

-------------------------------------------------------------------------------------------------------------------

CREATE PROCEDURE [dbo].[sp_find_branch](@bid int)

AS

begin

select * from branch where BranchId= @bid;

end