Static and Dynamic Anonymous User99921-Jun-2018What is Static and Dynamic SQL ?mysqlsql server sql sql update Updated on 22-Jun-2018
Prakash nidhi Verma
22-Jun-2018Differences between Static and Dynamic SQL:
STATIC SQL :
- it's application do not change at runtime.
- the application may allow users to enter their own queries.
- predetermined data
- It is more swift and efficient.
- statements are compiled at compile time.
- It is less flexible.
- can be hard-coded into the application.
DYNAMIC SQL :
- it's application constructed dynamiacally at run time.
- determined data at run time.
- It is less swift and efficient.
- statements are compiled at run time.
- It is more flexible.