What is the difference between static and dynamic sql?

Static sql is hard-coded in a program when the programmer knows the statements to be executed. For dynamic sql the program must dynamically allocate memory to receive the query results.
  • Interview Candidate
  • 3
  • 5469

Showing Answers 1 - 3 of 3 Answers

Yash Rajput

  • Aug 15th, 2017
 

Static SQL: 1) SQL statements are compiled at compile time.
2) more efficient.

Dynamic SQL: 1) SQL statements are compiled at run time.
2) Less efficient.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions