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
What is 'Join' and explain its various types.
Which is the main third-party tool used in sql server?
How to create a local temporary stored procedure?
What is the difference between indexing and hashing?
What is SQL Azure Fabric?
What is view in sql?
Why functions are used in sql server?
What are cascading parameters in ssrs reports?
Can we join two tables without primary key?
How to define and use table alias names in ms sql server?
Explain transaction server isolation?
How to get a list all databases on the sql server?
What is the difference between dropping a database and taking a database offline?
Explain in brief how sql server enhances scalability of the database system?
explain the storage models of olap? : Sql server database administration