What are the benefits of using stored procedures over sql
statements?
Answer Posted / vishnu
reduces network traffic
boost up the performance
eliminate webserver overhead
it takes input parameters
if we modify it, clients 'll get newer version automatically
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
How to execute the cursor queries with "open" statements?
Define Wed Edition in SQL Azure?
How is a full-text index updated?
Why we need sql server?
What are .mdf files?
In what version of sql server were synonyms released?
What is the importance of concurrency control?
Introduction of rollup clause using sum and group by clause?
How to use "if ... Else if ... Else ..." Statement structures in ms sql server?
What does it mean to invest in the index?
What is SQL Azure Firewall?
What is cached report?
Tell me what is a linked server?
What is the difference between ddl and dml?
Explain what you mean by 3 tier architecture.