Try my app Expense Manager @ google play and amazon store.

Monday, July 23, 2012

Advantages of Stored Procedure in Microsoft SQL Server


There are many advantages of using stored procedures in Microsoft SQL Server. These are :
  1. Easier to maintain and troubleshoot as they are modular.
  2. Stored procedures enable better tuning for performance.
  3. While using stored procedures is much easier from a GUI end than building complex queries.
  4. Stored procedures help in reducing network usage.
  5. Stored procedures provide more scalability to an application.
  6. Reusable and hence reduce code.
  7. Stored procedures can be part of a separate layer which allows separating the concerns. Hence Database layer can be handled by separate developers proficient in database queries.


4 comments:

  1. Kolkata web design company,
    IMESSOLUTION
    provides Custom Web Design, Web Development,E-commerce website design development,logo design,banner design,Business card design,graphic design and Search Engine Optimization at affordable prices. Our high-end services are
    incomparable to other competitor in the sense that our web design services are excellent while we provide best services without compromising with the quality of the work.

    ReplyDelete


  2. Thank you for posting such a useful, impressive.your blog is so beautiful. you have give me great news


    web developer in Gurgaon

    ReplyDelete
  3. Stored procedure remove the risk of SQL Injection :)

    ReplyDelete

Follow by Email

Google+ Badge