Stored Procedure Question: Download Questions PDF
Explain about the difficulties faced by the database developer in implementing pre compiled statements?
Answer:
There are many difficulties for implementing pre compiled statements because it should have all the arguments provided to it during compile time. It also depends upon the database and configuration. Performance also varies and it largely depends upon whether it is a generic query or user defined functions.
Download Stored Procedure Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Does storing of data in stored procedures increase the access time? Explain? | Explain about the implementation of business logic in Stored procedures? |