Services
Technology Web App Development Mobile App Development Windows App Development Database Development UI/UX Development Cloud Development SEO Digital Marketing Guest Posting Content Writing Artificial Intelligence Data Science ERP Development CRM Development CMS Development LMS Development Business Listing Blockchain Technology Startup Promotion AI Tools Integration
Products
Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller
Developer
Article Blog Forum Interview Beginner News Startup Quiz
Users
Career
Apply Job Internship
Pricing
Login Sign Up Get a Quote

forum

home / developersection / forums / why we are using stored procedure in sql server
Ask Question

Why we are using stored procedure in sql server

Anonymous User 2112 16 May 2013
Hi!

Why we are using stored procedure for set and get data with table. Please provide any example or demo or links where described it used with windows application and web application.

Your help is greatly appreciated.
Thanks in advance. 
mssql server mssql server
Updated 15 May 2026
Anonymous User
Anonymous User

Other

I am a content writter !

Message

1 Answers

AVADHESH PATEL
AVADHESH PATEL 16 May 2013
Report Abuse
Hi Chintoo!

Stored Procedure 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 
advertising