Using arrays in stored procedures

it.wily · #1 (**permalink**) 02-09-2008, 06:45 AM

i want to call a stored procedure sending array of integers as
parameter

now in stored procedure i want to execute

Code:

select * from Products where Prod_Code IN

(sent array)

means "sent array" stores values i want to check in query

please help

it.wily · #2 (**permalink**) 02-09-2008, 06:47 AM

Send them as a string of comma seperated values instead of an array. Then, in your sp, do this:

Code:

declare @sql varchar(1000)
Set @sql = 'Select * From Products Where Prod_Code IN (' + @values + ')'
exec(@sql)

Where @values is your parameter.

rick22 · #3 (**permalink**) 02-09-2008, 10:18 AM

try out the following code this thing will definitely work out:

declare @sql varchar(1000)
Set @sql = 'Select * From Products Where Prod_Code IN (' + @values + ')'
exec(@sql)

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to delete all stored procedures in a Database	oxygen	Database Support	1	03-05-2008 02:35 AM
NET Code generators for C# and SQL Stored Procedures	verrock_po	ASP and ASP.NET Programming	1	12-06-2007 12:22 AM
Using arrays in stored procedures	oxygen	Database Support	1	11-26-2007 08:01 AM
SQL Server Undocumented Stored Procedures	a.deeban	Database Support	3	09-04-2007 03:31 AM
Executing SQL Server Stored Procedures With PHP - Executing stored procedures	Jeyaseelansarc	PHP Programming	1	07-19-2007 12:23 AM