- How do I select multiple values in SQL?
- How to pass multiple values to one parameter in stored procedure in SQL?
How do I select multiple values in SQL?
To select multiple values, you can use where clause with OR and IN operator.
How to pass multiple values to one parameter in stored procedure in SQL?
Pack the values into one string with comma separated. Set the string as parameter and pass it into the SQL statement. Unpack the values and insert the values into a table, Where customerid in (select id from #temp)