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 a live lock? : Sql server database administration
what type of index will get created after executing the above statement? : Sql server database administration
How do I find the transaction log size in sql server?
What is the distinction amongst delete and truncate?
What does the not null constraint do?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to create a view using data from another view?
What are trace flags?
What is difference between count (*) and count column?
Can a trigger be created on a view?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
1 01 101 01010
What is openrowset sql server?
What is the difference between DATETIME2 and DATETIME?
How will you know when statistics on a table are obsolete?