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 stored by the model?
How to create a local temporary stored procedure?
How use inner join in sql server?
How do I completely remove sql server instance?
What is Sqlpaging in SqlServer 2005 ?
What is service broker? : sql server database administration
What is a View ? Can we insert, Update and delete a view?
What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?
How to drop an existing stored procedure in ms sql server?
Define model database?
How to execute a stored procedure in ms sql server?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
What is key attribute?
explain different types of backups avaialabe in sql server? : Sql server database administration
How do I start sql server 2017?