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
What is CTE in SQL
How to call stored procedure using http soap?
What are the properties of sub-query?
What is normalization? Describe its different types.
What is 1nf 2nf?
wat wil hapn if we give the both read and deny read permission to user?
Explain what is analysis service repository?
Explain following error properties?
Why we need sql server?
What is a rownum?
How can you fetch alternate records from a table?
What is Service Broker in sql server 2012?
Explain what is it unwise to create wide clustered index keys?
what are the important architecture components of SSRS?
Explain cdc and sql injection?