General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
I know its not very good programming practice, but I have passed comma delimited strings into sp's and concatanating it into a sql string and then executing it in the sp to achive this functionality. I wouldnt suggest doing this unless you need a quick fix. Reason being, (i think) is that the server cant store an execution plan for a dynamicaly created sql statement.
>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
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