Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 .NET Inside SQL Server (2005)
 how to pass array (query parameter) into stored pr

Author  Topic 

spshindagi
Starting Member

11 Posts

Posted - 2008-01-31 : 05:05:40
how to pass array(query parameter) into stored procudure. with this array i need to retrive data,with another array i have to retrive another set of data.
eg: suppose @param1 contains chapter1,Chapter2,Chapter3,
@param2 contains unit1.1,unit2.1,unit2.2,unit3.1,unit3.6
how can i do in stored procedure

love all

sunil
Constraint Violating Yak Guru

282 Posts

Posted - 2008-01-31 : 05:34:15
http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm
Go to Top of Page
   

- Advertisement -