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.
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
Tell me about builtinadministrator?
What are the steps to follow to configure SQL*Net?
Explain different types of locks in sql server.
What is inline table-value user-defined function?
How to create a ddl trigger using "create trigger" statements?
Which are new data types introduced in sql server 2008?
explain declarative management framework (dmf) in sql server 2008?
How does the report manager work in SSRS?
What is the purpose of indexing?
What does the update command do?
What is the difference between composite index and covering index?
What is data mart? : sql server analysis services, ssas
What is the correct order of the logical query processing phases?
What are commonly used odbc functions in php?
What are data driven subscriptions?