SQL Stored Procedure (INSERT / UPDATE / DELETE)

Stored Procedure ( Insert ,Delete, Update )
---------------------------------------------------------------
create procedure SPS_Designation_Add

@Designation VarChar(50)

As Begin
insert into Tbl_Designation
(Designation)
values
(@Designation)
end
-------------------------------------------------------------

create procedure SPS_Designation_Update

@Designation VarChar(50),
@DesignationSID int

As Begin
update Tbl_Designation
set
Designation=@Designation
where
DesignationSID=@DesignationSID
end
--------------------------------------------------------------
create procedure SPS_Designation_Delete

@Designation VarChar(50),
@DesignationSID int

As Begin
delete from Tbl_Designation
where
DesignationSID=@DesignationSID
end