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, 11:53 PM   #1
chinmay.sahoo
Registered User
 
Join Date: Dec 2013
Location: Banglore
Posts: 312
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, 03:14 AM   #2
ankur111
Registered User
 
Join Date: Jun 2016
Location: Van Nuys
Posts: 32
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.
|
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, 05:25 AM   #3
ITSGOLIVE
Registered User
 
Join Date: Dec 2016
Posts: 80
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
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 09:53 AM
SQL Server and PHP williamcastro22 PHP / mySQL 16 06-04-2012 03: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 03:10 PM
??? Highly Reliable Dedicated Server Hosting In India By Host.co.in ??? Kailas Post your ad here 0 04-11-2012 07:42 AM
Fully Managed Dedicated Server Hosting in India by Host.co.in Kailas Post your ad here 0 02-14-2012 11:03 AM


All times are GMT -7. The time now is 02:50 PM.


Powered by vBulletin Copyright © 2013 vBulletin Solutions, Inc.