Insert, select, update and delete stored procedure in sql server.

1. Insert stored procedure :

create proc sp_tbl_Employee_Insert
(
@name nvarchar(50),
@gender nvarchar(50),
@salary nvarchar(50)
)
as
begin
insert into tbl_Employee
(name, gender, salary)
values
(@name, @gender, @salary)
end

2. Select stored procedure :

create proc sp_tbl_Employee_Select
as
begin
select * from  tbl_Employee
end

3. Update stored procedure :

create proc sp_tbl_Employee_Update
(
@id int,
@name nvarchar(50),
@gender nvarchar(50),
@salary nvarchar(50)
)
as
begin
update tbl_Employee set
name=@name,
gender=@gender,
salary=@salary
where id = @id
end

4. Delete stored procedure :

create proc sp_tbl_Employee_delete
(
@id int
)
as
begin
delete  from  tbl_Employee
where id = @id
end