With static SQL, host variables used in embedded SQL statements are known at application compile time. With dynamic SQL, the embedded SQL statements and consequently the host variables are not known ...

Debugging dynamic ... be slightly different. This variability can introduce bugs that are hard to catch because they don't always appear. To address this, you can log the actual SQL statements ...

This allows SQL Server to reuse cached plans for similar statements, and to avoid plan cache pollution by limiting the number of different plans stored in memory. Dynamic SQL should be used ...

If the programmer knows exactly what the query is going to do, and the query does not change, it is called "static SQL." If the query requires user input at runtime, it is called "dynamic SQL." ...

See the Administration Guide for details about the different privileges ... The privileges required depend on whether your application uses dynamic SQL (either embedded or CLI) or static SQL, and on ...