Interested to Buy Any Domain ? << Click Here >> for more details...
What are the benefits of using stored procedures over sql
statements?
- 3 Answers
- 8332 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 denormalization? : Sql server database administration
How to find out what is the default collation in a database?
What are parameterized reports?
Explain the steps to create and execute a user-defined function in the sql server?
What is the order in which the sql query is executed?
What happens to a statement batch if there is a compilation error?
What is t-sql script to take database offline – take database online.
Can we perform backup restore operation on tempdb? : sql server database administration
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
What happens when unicode strings concatenate with non-unicode strings?
How you trouble shoot when any job fails
How to test values returned by a subquery with the in operator?
Can We Use Data-grids For Our Report In Ssrs?
what are defaults? Is there a column to which a default can't be bound? : Sql server database administration
What number sorts of privileges are accessible in sql?
