---
title: "How to Create a procedure for Delete record by ID ?"  
description: "How to Create a procedure for Delete record by ID ?"  
author: "Anonymous User"  
published: 2018-07-31  
updated: 2018-07-31  
canonical: https://www.mindstick.com/forum/34642/how-to-create-a-procedure-for-delete-record-by-id  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# How to Create a procedure for Delete record by ID ?

\

## Replies

### Reply by Anonymous User

```
//----------Delete Record By ID---------//

CREATE PROC ContactDeleteByID
@ContactID int
AS
Begin
 Select * from Contact
 where ContactID=@ContactID
END
```

NOTE:- 1). Don’t make space between parameter name Like : Student Name -------- (wrong syntax). Student_Name or StudentName -------- (Correct Syntex). 2). When You need to update Stored Procedure then you use ALTER keyword place on CREATE. And execute procedure after the update. \


---

Original Source: https://www.mindstick.com/forum/34642/how-to-create-a-procedure-for-delete-record-by-id

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