| Executive Summary: One way to use arrays as input for stored procedures in Microsoft SQL Server is to employ dynamic SQL. |
Stored procedures don’t support arrays as inputs,
but there’s a common need to develop procedures
that accept an unknown number of input
parameters. For example, suppose you need to create a
procedure in the Northwind database that accepts an
unknown number of ...