Passing a List as a SQL Parameter

Take a simple query something like this:

select * from Orders
where OrderID in (1724, 1722, 1710)
order by OrderID desc

In the course of using this query, we might try input it's values as parameters. 

select * from Orders
where OrderID in (@ord1, @ord2, @ord3)
order by OrderID desc

But we don't always know how  many of them there are.  For this case we need what is called a table valued parameter - or a list parameter.









...

---

Bryan Valencia is a contributing editor and founder of Visual Studio Journey.  He owns and operates Software Services, a web design and hosting company in Manteca, California.