Using arrays in stored procedures
This is a discussion on Using arrays in stored procedures within the Database Support forums, part of the Web Development category; Using arrays in stored procedures i want to call a stored procedure sending array of integers as parameter now in ...
| |||||||
| Register | FAQ | Members List | Calendar | Mark Forums Read |
11-26-2007, 06:59 AM
| |||
| |||
 Using arrays in stored procedures Using arrays in stored procedures 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
__________________ The OXYGEN Delivers edgy, intelligent Technology to all...     |
| Sponsored Links |
|
11-26-2007, 07:01 AM
| |||
| |||
| Re: Using arrays in stored procedures Hi, 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.
__________________ S.Balasubramanian Nothing is impossible |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear 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 01:35 AM |
| Using arrays in stored procedures | it.wily | Database Support | 2 | 02-09-2008 09:18 AM |
| NET Code generators for C# and SQL Stored Procedures | verrock_po | ASP and ASP.NET Programming | 1 | 12-05-2007 11:22 PM |
| SQL Server Undocumented Stored Procedures | a.deeban | Database Support | 3 | 09-04-2007 02:31 AM |
| Executing SQL Server Stored Procedures With PHP - Executing stored procedures | Jeyaseelansarc | PHP Programming | 1 | 07-18-2007 11:23 PM |
All times are GMT -7. The time now is 12:31 PM.
