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 and 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?

Anonymous User

Can you answer this question?

1 Answers

Liked By