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 the stored procedure?
What are the mathematical functions supported by sql server 2005?
What is the purpose of grouping data in a report?
What is sql server management studio? : sql server management studio
What is normalization of database?
Explain intellisense for query editing
What is transaction server consistency?
Is it possible for a stored procedure to call itself or recursive stored procedure?
Explain the Ways to improve the performance of a sql azure database?
How do you troubleshoot errors in a SQL Server Agent Job?
What is user-defined inline table-valued function?
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to use transact-sql statements to access the database engine?
What is the maximum size of column in sql server?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?