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.
- 3 Answers
- 5722 Views
- 247Customer, I also Faced
- E-Mail Answers
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
Difference between connected and disconnected database in .net with sql server?
What are blobs, tables, and Queues? Is SQL is the standard way to query blobs, tables, and queues?
What is the largest component inside a field?
Which language is supported by sql server?
can a table be moved to different filegroup? : Sql server administration
Can an automatic recovery be initiated by a user?
what is normalization? Explain different levels of normalization? : Sql server database administration
In what version of sql server were synonyms released?
What is the maximum size per database for sql server express?
What is catalog views?
 Explain what is sql override for a source taLle in a mapping?
Describe triggers features and limitations?
What is buffer cash in sql server?
What are distinctive joins find as a part of sql?
How many databases instances are there in sql server 2000?
