Interested to Buy Any Domain ? << Click Here >> for more details...
What are the benefits of using stored procedures over sql
statements?
- 3 Answers
- 8273 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
Explain indexed views and partitioned view with their syntax.
What can be used instead of trigger?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
Can group functions be used in the order by clause in ms sql server?
Can you index views?
What is standby servers? Explain types of standby servers.
Does index speed up select statements?
What do you mean by acid?
How to Check if table exists in sql server?
Explain features of analysis services?
How do I make a resultset scrollable?
What are the ways available in sql server to execute sql statements?
as a part of your job, what are the dbcc commands that you commonly use for database maintenance? : Sql server database administration
What do you mean by subquery?
what is the difference between delete table and truncate table commands? : Sql server database administration
