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
explain different levels of normalization? : Sql server database administration
Where sql server usernames and passwords are stored in a sql server?
What is a covered index?
What is view in sql?
How retrieve field names from the table in SQL through JAVA code?
what is a mixed extent? : Sql server administration
How can you hide the sql server instances?
Explain following error properties?
how would you write a sql query to compute a frequency table of a certain attribute involving two joins? What changes would you need to make if you want to order by or group by some attribute? What would you do to account for nulls?
What are drilldown reports?
After removing a table from database, what other related objects have to be dropped explicitly?
What is indexing explain it with an example?
Explain the benefits of user-defined functions?
What are views in ms sql server?
IF more than one Site is accessing the same Database server and I want to move the DB with Minimum down time? How will you do