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 are the properties of primary key?
What is the syntax to execute the sys.dm_db_missing_index_details?
What is the difference between count and distinct count?
Tell me what is the difference between locking and multi-versioning?
What is the difference between seek predicate and predicate?
How to loop through result set objects using odbc_fetch_row()?
What is the distinction amongst delete and truncate?
How to enable/disable indexes?
What are the difficulties faced in cube development? : sql server analysis services, ssas
Explain about link server in sql server?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
Define tool Manage Statistics in SQL Server 2000 query ?
Which are the important points to note when multilanguage data is stored in a table?
How would you add a section to a table?
How can I check that whether automatic statistic update is enabled or not?