General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
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. :)
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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only