How write store procedure that accepts mutliple parameter for a single column?
Posted on 2011-04-20
I have a table TABLE1. It has 4 columns. COL1, COL2, COL3, COL4. I want to select data from this TABLE1 by passing input parameters from my ASP.Net application and this store procedure return data result back to the application.
This store procedure will have a SELECT SQL. For column COL1, I might be pass more than one input parameter. The number input parameters are not consistent, they might be one or more than one. I want my store procedure to be able to take one or more than one input parameter for a single column. How can I do this?