Register on the forum now to remove ALL ads + popups + get access to tons of hidden content for members only!

Go Back   Site Owners Forums - Webmaster Forums > Web Programming > Programming General > ASP


Thread Tools Rate Thread Display Modes
Old 12-15-2016, 10:53 PM   #1
Registered User
Join Date: Dec 2013
Location: Banglore
Posts: 336
Send a message via AIM to chinmay.sahoo Send a message via MSN to chinmay.sahoo
Arrow What are the Advantages of Stored Procedure in SQL Server?

• Execution plan retention and reuse

• Encapsulation of business rules and policies

• Sharing of application logic between applications

• Access to database objects that is both secure and niform

• Consistent, safe data modification

• Network bandwidth conservation

• Improved security

• Reduced development cost and incr as d r liability

• Centralized security, administration, and maint nance for common routines.

Asthijivak | Roop Amrit | Slim Shaper |
chinmay.sahoo is offline   Reply With Quote

Old 01-17-2017, 02:14 AM   #2
Registered User
Join Date: Jun 2016
Location: Van Nuys
Posts: 40
They are easier to maintain and troubleshoot as they are modular.
- Stored procedures enhance the performance.
- Using them is much easier from a GUI end than building or using complex queries.
- They can be part of a separate layer which enables database layer to be handled by separate developers who are proficient in database queries.
- Reduce network usage.
- Increases scalability.
- The code can be reused and hence will save time.
ankur111 is offline   Reply With Quote
Old 01-17-2017, 04:25 AM   #3
Registered User
Join Date: Dec 2016
Posts: 137
Oh actually i did not get anything.
ITSGOLIVE is offline   Reply With Quote
Old 03-16-2017, 12:03 AM   #4
Registered User
Join Date: Jan 2017
Location: Ahmedabad
Posts: 126

Stored Procedure Is Pre-Complied SQL Statement that is Run in client Computer. If we have to use Stored Procedure then our Application Complilation Time is reduced because its Previously Complied in to Sql server.

and one of the main Advantage of using Stored Procedure is chance of SQl Injection is very Less so our Application Become A Very Secure.

Divyesh Padamani
Sonvi Belani
Ecommerce Website Developer
custom software companies India
ASP.NET software companies India
sonvi.belani is offline   Reply With Quote

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Windows Hosting on IIS 8 Server with Free SQL 2012 Database thewebhosting Web Promotion 1 04-04-2013 08:53 AM
SQL Server and PHP williamcastro22 PHP / mySQL 16 06-04-2012 02:14 AM managed servers-Get 500 GB backup space free-15% Off storminternet Post your ad here 0 05-08-2012 02:10 PM
??? Highly Reliable Dedicated Server Hosting In India By ??? Kailas Post your ad here 0 04-11-2012 06:42 AM
Fully Managed Dedicated Server Hosting in India by Kailas Post your ad here 0 02-14-2012 10:03 AM

All times are GMT -7. The time now is 10:55 PM.

Powered by vBulletin Copyright © 2013 vBulletin Solutions, Inc.