Stored Procedure Question:
Download Questions PDF

Explain about the difficulties faced by the database developer in implementing pre compiled statements?


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 QuestionNext Question
Does storing of data in stored procedures increase the access time? Explain?Explain about the implementation of business logic in Stored procedures?