Join the social network of Tech Nerds, increase skill rank, get work, manage projects...
 
  • Advantages of using stored procedures :

    • 0
    • 1
    • 1
    • 1
    • 0
    • 0
    • 0
    • 0
    • 309
    Comment on it

    Stored Procedures

    stored procedures is the collection of Sql statements which is stored in data base .

    below are the advantage of stored procedures :

    1.stored procedures reducing network traffic and boost application performance. .

    2.stored procedure execute plans can be reused, they stay cached in sql server's memory and also reduce server overhead .

    3.stored procedure helps by reusing of code .

    4.stored procedure can encapsulate logic, one can change stored procedure code without effecting clients .

    5.stored procedure provide better security to data .

 0 Comment(s)

Sign In
                           OR                           
                           OR                           
Register

Sign up using

                           OR                           
Forgot Password
Fill out the form below and instructions to reset your password will be emailed to you:
Reset Password
Fill out the form below and reset your password: