Skip to main content


 

Symptoms


How do I specify parameter within an ADO Query
 

Diagnoses


How do I specify parameter within an ADO Query
 

Resolution

To specify a parameter within an ADO query, please use the 'HAVING' statement.
Example:

SELECT * FROM OSmartobject].tMethod] HAVING NParameter] = Value]

SELECT * FROM Book.List HAVING p_Name = 'Lord of the Ring'




 

Is it possible to pass Multiple parameter values? 

I need to pass  Parameter1 Name in ('test','test1')

and parameter 2 date =('02/07/2018')


Reply