Dynamic SQL Going Haywire


Those who work on various databases, or even those who do not, must have come across the term, Dynamic SQL. Dynamic SQL is basically a programming technique that enables you to build SQL statements dynamically at run time. It allows you to create more general purpose flexible SQL statement because the full text of the SQL statements may be unknown at compilation. For example, you can use Dynamic SQL to create a stored procedure that queries data against a table whose name is not known until run time. Even with the benefits, there could also be problems and concerns. I