---
title: "How to Create a Common Stored Procedure For Insert Update and Delete ?"  
description: "How to Create a Common Stored Procedure For Insert Update and Delete ?"  
author: "Anonymous User"  
published: 2018-07-31  
updated: 2018-07-31  
canonical: https://www.mindstick.com/forum/34644/how-to-create-a-common-stored-procedure-for-insert-update-and-delete  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to Create a Common Stored Procedure For Insert Update and Delete ?

\

## Replies

### Reply by Anonymous User

```
CREATE PROCEDURE MasterInsertUpdateDelete
(

@ContactID int,
@Name varchar(50),
@Mobile varchar(50),
@Address varchar(250),
@Query int
)
AS
BEGIN
IF(@Query = 1)
BEGIN
Insert into Contact
(
Name ,
Mobile ,
Address
)
values
(
@Name ,
@Mobile ,
@Address
)
IF(@@ROWCOUNT > 0)
Begin
Select 'Insert'
End
End
IF(@Query = 2)
Begin
Update Contact
set
Name =@Name ,
Mobile =@Mobile ,
Address = @Address
where ContactID =@ContactID
Select 'Update'
End

IF(@Query = 3)
Begin
Delete from Contact where ContactID =@ContactID
Select 'Deleted'
End

IF(@Query = 4)
Begin
Select * from Contact
End
End

IF(@Query = 5)
Begin
Select * from Contact where ContactID =@ContactID
End
```

![How to Create a Common Stored Procedure For Insert Update and Delete ?](https://www.mindstick.com/mindstickforums/0d9f57eb-eafe-4efd-b8a7-0baac1893e95/images/46ccaf4d-7fac-40a4-9db9-a31101b9692c.png)\


---

Original Source: https://www.mindstick.com/forum/34644/how-to-create-a-common-stored-procedure-for-insert-update-and-delete

Copyright © MindStick Software Pvt. Ltd. This Markdown version is provided for developers, AI systems, and offline reading.