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.
Answer Posted / 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 |
Post New Answer View All Answers
How to optimize stored procedure optimization?
What is checkpoint process in the sql server?
What is the difference between stored procedure and user defined functions?
How to replace null values in expressions using isnull()?
What are the new features of sql server 2012 reporting service?
How can sql injection be stopped? : sql server security
What are the grouping functions?
What the different components of Replication and what is their use?
Mention the different types of replication in sql server.
How can we delete Duplicate row in table?
what is database replicaion? : Sql server database administration
What does this statement do @@rowcount?
Explain why variables called the most powerful component of ssis?
Do you know how to make remote connection in database?
How to count groups returned with the group by clause in ms sql server?