No ratings

How do I specify parameter within an ADO Query




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 [Smartobject].[Method] HAVING [Parameter] = [Value]

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





Comments

Is it possible to pass Multiple parameter values? 

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

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

Version history
Last update:
‎01-30-2015 04:23 PM
Updated by:
Contributors