SQL Server doesn't support anything like an array. Currently I use XML and the OPENXML() rowset function to achieve the same functionality.
-Mike
>i would like to pass an array of integers to a stored procedure from an asp.net application to use like:
>strsql = "SELECT * FROM table WHERE ID IN (@array)"
>can this be done? if so, how do i do this? i can send a string to the stored procedure but it doesnt return any results because the it is expecting to match on an int.
>thanks in advance,
>tim