Results 1 to 2 of 2

Thread: What are the Advantages of Stored Procedure in SQL Server?

  1. #1
    Senior Member
    Join Date
    Jun 2015
    Posts
    166
    Thanks
    0
    Thanked 0 Times in 0 Posts

    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.

  2. #2
    Junior Member
    Join Date
    Apr 2017
    Location
    USA
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Excellent points covered. Stored procedures should be used in projects to keep its execution speed fast and development cost low. I have seen people who don't have knowledge about S.P. blindly writing the database queries which make the project heavy and slow.
    Pass Microsoft Certification Without Taking Exam

Similar Threads

  1. How to install joomla on local server
    By johnmacklen in forum Web Programming
    Replies: 6
    Last Post: 01-25-2014, 09:15 AM
  2. Does JAVA works with Sql server?
    By abbie in forum Web Programming
    Replies: 1
    Last Post: 01-16-2013, 03:42 PM
  3. Add 10 numbers stored in consecutive memory locations
    By abbie in forum Web Programming
    Replies: 1
    Last Post: 01-16-2013, 03:39 PM
  4. Server side language which is best PHP or ASP.NET?
    By Darren in forum Web Programming
    Replies: 2
    Last Post: 01-10-2013, 10:27 AM
  5. My Webhosting server is down already twice in 24 hours.
    By mam in forum Internet Marketing Discussions
    Replies: 0
    Last Post: 01-07-2013, 04:09 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •