>I know this thread has been inactive for a while but I just wanted to say thanks to you for the openxml tip. I now do all my stored procs with no dynamic sql. :)
You're welcome.
-Mike
>
>Eric Stephani
>
>>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