---
title: "Why we are using stored procedure in sql server"  
description: "Why we are using stored procedure in sql server"  
author: "Anonymous User"  
published: 2013-05-16  
updated: 2026-05-15  
canonical: https://www.mindstick.com/forum/902/why-we-are-using-stored-procedure-in-sql-server  
category: "mssql server"  
tags: ["mssql server"]  
reading_time: 1 minute  

---

# Why we are using stored procedure in sql server

Hi!\
Why we are using [stored procedure](https://www.mindstick.com/articles/803/using-stored-procedure-in-asp-dot-net) for set and get [data](https://www.mindstick.com/articles/13050/salesforce-aiming-to-dominate-predictive-analytics-with-data-science) with table. Please provide any example or [demo](https://www.mindstick.com/forum/157370/how-to-swap-neighbor-characters-in-string-e-g-string-demo-would-be-edom) or [links](https://www.mindstick.com/blog/415/css3-links) where described it used with [windows](https://www.mindstick.com/articles/311752/how-to-install-and-use-the-google-wifi-software-on-a-windows-or-mac-computer) application and [web application](https://www.mindstick.com/articles/13069/progressive-web-application-pwas-all-you-need-to-know-about).\
Your help is greatly appreciated.Thanks in advance.

## Replies

### Reply by AVADHESH PATEL

Hi Chintoo! \
[Stored](https://www.mindstick.com/forum/157561/what-is-the-stored-procedure-create-a-procedure-to-find-the-record-by-stu_id-from-the-student-table) [Procedure](https://www.mindstick.com/forum/32/stored-procedure-return-datatype) are used to hide table information. Mostly sp are used for preventing sql injection. Read following articles that help you to sp used and how to prevent sql injection. \
http://www.mindstick.com/Articles/79be36ec-d4e6-4ef5-ae5d-c65fd7ede2b9/?Stored%20Procedure%20in%20SQL \
http://mindstick.com/Articles/3678ebe0-5c9b-4237-9465-347e15331723/?Using%20Stored%20Procedure%20in%20ASP.Net \
http://www.mindstick.com/Articles/25646e65-b217-495d-afb8-5f02ce94b7eb/?Prevent%20SQL%20Injection%20in%20ASP.NET


---

Original Source: https://www.mindstick.com/forum/902/why-we-are-using-stored-procedure-in-sql-server

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