Interested to Buy Any Domain ? << Click Here >> for more details...
What are the benefits of using stored procedures over sql
statements?
- 3 Answers
- 8162 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
How does a profiler work?
How to create a local temporary stored procedure?
What do you understand by physical_only option in dbcc checkdb?
What stored by the model? : sql server database administration
Is it ok to shrink transaction log?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
Explain few examples of stored procedure over triggers?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
What are joins in sql and what are the different types of joins?
What are sparse columns?
What is the stuff?
Can you force a query to use a specific index?
What is the difference between Triggers and Stored Procedure?
How many triggers you can have on a table?
What is use of dbcc commands?
