Dynamic SQL

Dynamic SQL statements are those that are not compiled until the stored procedure in which they are contained is executed. This feature allows SQL statement strings to be dynamically constructed (e.g., from stored procedure arguments), compiled (i.e., prepared) and executed. Two statements support dynamic SQL: PREPARE and EXECUTE.