In this book, you have seen many examples of pages that are customized by session state values. For example, the SQL source query of a report is a good candidate for customization, as is an SQL statement in a process that accesses the database. A large portion of this customization comes from bound references in SQL statements.
However, there are limits to what can be customized. A reference to a session-state variable can replace a constant in the SQL query, but it is not allowed to replace a table name or a column name. In this chapter, you will examine a technique called dynamic SQL, which overcomes this limitation by ...