Pass value into sql in statement

[wangxianlg]

Hi,

I would like to pass value like '7002', '6997' into sql statement using in statement like following:

select * from users where id in (@Ids)

the @Ids value looks like '7002', '6997'

Please help!

Thanks
Alan

[HighAley]

Hello, Alan.

I would like to pass value like '7002', '6997' into sql statement using in statement like following:

select * from users where id in (@Ids)

the @Ids value looks like '7002', '6997'

We don't support list parameters in SQL query but you could use a variable of type string.

Code: Select all

select ... from ... where id in ({var1})

Where var1 = "'7002', '6997'"

Thank you.