stored procedure

create proc insert_departmentmaster

(
@Branch_Code nvarchar(MAX),
@Dept_No nvarchar(MAX),
@Dept_Name nvarchar(MAX)
)
as
begin
insert into DepartmentMaster(Branch_Code,Dept_No,Dept_Name)values(@Branch_Code,@Dept_No,@Dept_Name)
end

create proc delete_departmentmaster
(
@Id bigint
)
as
begin
delete from DepartmentMaster where Id=@Id
end

create proc update_departmentmaster
(
@Id bigint,
@Branch_Code nvarchar(MAX),
@Dept_No nvarchar(MAX),
@Dept_Name nvarchar(MAX)
)
as
begin
update DepartmentMaster set Branch_Code=@Branch_Code,Dept_No=@Dept_No,Dept_Name=@Dept_Name where Id=@Id
end

create proc select_departmentmaster
as
begin
select * from DepartmentMaster
end