What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.
Answers were Sorted based on User's Feedback
Answer / paras
If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar sharma
You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.
Is This Answer Correct ? | 2 Yes | 0 No |
What is autocommit mode in sql server?
What is 'write-ahead log' in sql server 2000 ?
What is single-user mode and what are the steps you should follow to start sql server in single-user mode?
What are the 2 types of classifications of constraints in the sql server?
What do you understand by triggers?
what is the system function to get current user's user id? : Sql server database administration
When you use @@error and try-catch?
What is nolock hint in sql server 2008
What is wide table?
what is cursor?why we will go to cursor?advantages &disadvantages of cursors?
What are constraints?
What is the difference between left and right outer join?