Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 6546 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
What is the filtered index?
How to run queries with sql server management studio express?
What is difference between index seek vs. Index scan?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
What is an indexed view?
How do I view a trc file?
What is the difference between ddl and dml?
What are subquery and its properties?
How do I start sql server?
How to insert stored procedure result into temporary table?
What are the 2 types of classifications of constraints in the sql server?
Explain index in sql server?
What are out-of-range errors with date and time literals?
what changed between the previous version of sql server and the current version? : Sql server database administration
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
