What is dynamic where clause ?? Where is it used?
Printable View
What is dynamic where clause ?? Where is it used?
My best guess is that you are talking about the WHERE clause for a Dynamic SQL statement. A dynamic SQL statement is one that you build 'on the fly', often dependant upon user input. For example, the user is on a Search screen with a bunch of control. Based on what values are filled in, you build the appropriate SQL statement including the WHERE clause.
- Chris