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
- 5694 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
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is a synonym for manipulation?
How to insert stored procedure result into temporary table?
What are types of storage modes? : sql server analysis services, ssas
What is difference between aggregate and analytic function?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
What is dbcc updateusage?
What is side by side migration in sql server?
What are sp_configure commands and set commands?
List the different types of joins?
Tell me what is use of except clause? How it differs from not in clause?
Define indexes?
How to create hyperlink from returned sql query ?
What is the advantage of sql server?
Do you know what are the properties of the relational tables?
