saravanakumar radhakrishnan
Why I have to use stored procedures?
By saravanakumar radhakrishnan in C# on Feb 09 2014
  • Mahesh Kumar Alanka
    Apr, 2014 26

    They are precompiled and is stored in Database. SP's reduces the Server load to Compile the Queries.

    • 1
  • Mukesh Kumar
    Sep, 2017 5

    For security

    • 0
  • Ranjit Powar
    Apr, 2014 22

    Simple sql queries complied every time during execution but stored procedures are precomplied hence the execution time of execution is reduced.

    • 0
  • Munesh Sharma
    Apr, 2014 4

    If there is a situation where we write a query again and again then we write that query as stored procedure and we call it by its name.

    • 0
  • Satish Rajnale
    Feb, 2014 28

    store procedure is compiled statement that why is faster and also it is more secure

    • 0
  • Dhinakaran
    Feb, 2014 20

    A benefit of stored procedures is that you can centralize data access logic into a single place that is then easy for DBA's to optimize. Get DataBase result sets from some business logic on data. Execute multiple DB operation at single call.

    • 0
  • srikanth divvela
    Feb, 2014 14

    Stored Procedure can reduce network traffic. An operation requiring hundreds of lines of Transact-SQL code can be performed through a single statement that executes the code in a procedure, rather than by sending hundreds of lines of code over the network

    • 0
  • Lakshmanan Sethu Sankaranarayan
    Feb, 2014 11

    Stored procedure are precompiled objects. so execution time is much better than inline queries.

    • 0
  • suresh Shewale
    Feb, 2014 10

    1. Stored procedures are used for performance factor 2. Also Stored procedures are secure than Inline queries

    • 0


Most Popular Job Functions


MOST LIKED QUESTIONS