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.
- 3 Answers
- 6606 Views
- 247Customer, I also Faced
- E-Mail Answers
Answer Posted / santosh kumar sharma
You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Explain system functions or built-in functions? What are different types of system functions?
Why use identity in sql server?
How to convert character strings into numeric values?
How do I find query history in sql server?
How to rebuild the master database?
What is acid mean in sql server?
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
What is a coalesce function?
what is the difference between openrowset and openquery?
What are different types of constraints?
what is spatial nonclustered index
Why and when do stored procedure recompile?
How can we solve concurrency problems?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
