I have created a store procedure with input paramenter @param1 of integer type to return result from a select statement as below:
SELECT * FROM TableABC WHERE columnabc LIKE (@param1)
the columnabc in the WHERE clause is of integer type.
I will like to be able to pass multiple values of integer to @param1, such as @param1 = 1, 2, 3.
Please advise how do I achieve that?
View Complete Post