How can you create dynamic query?

Question

Anonymous User · Answer

Dynamic SQL is a SQL code that your program generates using variables before the SQL is executed.
In coldfusion, CFQUERY give full provision to write all conditional logic & looping to derive the dynamic sql statement to execute. You can use dynamic SQL to accomplish tasks such as adding WHERE clauses to a search based on the fields that the user filled out on a search criteria page.

interview

How can you create dynamic query?

Can you answer this question?

1 Answers