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

Notices


Reply
 
Thread Tools Rate Thread Display Modes
Old 12-15-2016, 10:53 PM   #1
chinmay.sahoo
Registered User
 
Join Date: Dec 2013
Location: Banglore
Posts: 329
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 |
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
chinmay.sahoo is offline   Reply With Quote

Old 01-17-2017, 02:14 AM   #2
ankur111
Registered User
 
Join Date: Jun 2016
Location: Van Nuys
Posts: 34
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.
__________________
Baymediasoft is
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
offering
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
|
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
| and
To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
.
ankur111 is offline   Reply With Quote
Old 01-17-2017, 04:25 AM   #3
ITSGOLIVE
Registered User
 
Join Date: Dec 2016
Posts: 125
Oh actually i did not get anything.
__________________

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
ITSGOLIVE is offline   Reply With Quote
Old 03-16-2017, 12:03 AM   #4
sonvi.belani
Registered User
 
Join Date: Jan 2017
Location: Ahmedabad
Posts: 126
Hi,

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.

Thanks,
Divyesh Padamani
__________________
Sonvi Belani
Ecommerce Website Developer

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.


To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
sonvi.belani is offline   Reply With Quote
Reply


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
storminternet.co.uk-Fully 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 Host.co.in ??? Kailas Post your ad here 0 04-11-2012 06:42 AM
Fully Managed Dedicated Server Hosting in India by Host.co.in Kailas Post your ad here 0 02-14-2012 10:03 AM


All times are GMT -7. The time now is 08:27 AM.


Powered by vBulletin Copyright © 2013 vBulletin Solutions, Inc.