How to write insert, update, delete and status by stored procedure in sqlserver?

INSERT
________________________________________________________________________
CREATE procedure [dbo].[sp_SaveCMS]
(
@Title nvarchar(155),
@Description ntext,
@seo_keywords nvarchar(255),
@seo_descriptions nvarchar(255),
@Image nvarchar(255),
@PageId int
)
As
Begin
Declare @Id int
Set @Id = 0
Begin
Insert Into CMS
(
Title,
[Description],
seo_keywords,
seo_descriptions,
[Image],
PageId
)
Values
(
@Title,
@Description,
@seo_keywords,
@seo_descriptions,
@Image,
@PageId
)
Set @ID=SCOPE_IDENTITY()
--Set @StudentId=@@IDENTITY()
End
Select @Id As ID
End

UPDATE
_____________________________________________________________________________

CREATE procedure [dbo].[sp_UpdateCMS]
(
@Id int,
@Title nvarchar(155),
@Description ntext,
@seo_keywords nvarchar(255),
@seo_descriptions nvarchar(255),
@Image nvarchar(255),
@PageId int
)
As
Begin
Update  CMS
Set
Title = @Title ,
[Description] = @Description ,
seo_keywords = @seo_keywords ,
seo_descriptions = @seo_descriptions ,
[Image]=@Image,
PageId=@PageId
Where
ID=@Id
End
_____________________________________________________________________________

CREATE proc [dbo].[up_InsertUpdateCMS]
@Id int,
@Title nvarchar(100),
@Description nvarchar(Max),
@Seo_Keywords nvarchar(500),
@Seo_Descriptions nvarchar(500)
as begin
if (@Id > 0)
begin
update dbo.CMS set Title=@Title, Description=@Description,Seo_Keywords=@Seo_Keywords, Seo_Descriptions=@Seo_Descriptions
where Id=@Id
end
else begin
insert into dbo.CMS(Title, Description, Seo_Keywords, Seo_Descriptions)
 values(@Title,@Description,@Seo_Keywords,@Seo_Descriptions)
end
end

____________________________________________________________________________

DELETE

CREATE proc [dbo].[up_DeleteCMS]
@Id int
as
begin
delete from dbo.CMS where Id=@Id
end

CREATE proc[dbo].[up_UpdateAdStatus]
@AdID int,
@Ad_IsActive int
as
begin
update dbo.AdsMaster set Ad_IsActive=@Ad_IsActive where AdID=@AdID
end