Interested to Buy Any Domain ? << Click Here >> for more details...
What are the benefits of using stored procedures over sql
statements?
- 3 Answers
- 8317 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / vishnu
reduces network traffic
boost up the performance
eliminate webserver overhead
it takes input parameters
if we modify it, clients 'll get newer version automatically
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What is an indice?
Does partitioning help performance?
Explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What the different components of Replication and what is their use?
how to determine the service pack currently installed on sql server? : Sql server database administration
How to connect sql server management studio express to sql server 2005 express?
1)what is the difference between Reinitializing a Subscription and synchronization the subscription? 2)when to use reinitializing ? 3)when to use synchronization? 4)when adding table or deleting a table what to do?(reinz.. or syn) 5)when adding a column what to do?
What stored by the master? : sql server database administration
How to drop an existing user defined function in ms sql server?
Can the “if update (colname)” statement be used in a delete trigger?
Explain the stored procedure?
What is sql server profiler?
What is measure group, measure? : sql server analysis services, ssas
What is cte (common table expression)?
What are subquery and its properties?
