H
Håvard Danielsen
Guest
Technically the difference between a static and dynamic query is that static is defined and dynamic is created. As mentioned in previous responses the static query is bound to the tables at run time. However, the query expression ('where' clause and 'by' clause) can be changed "dynamically" at run-time also in a static query. The main limitation of static queries is that you cannot change the tables or the table order at run-time. Changing the tables of a query rarely makes any sense, but changing the table order can be very important for a query that accesses database tables.
Continue reading...
Continue reading...