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.
| Author |
Topic |
|
arunsqladmin
Yak Posting Veteran
74 Posts |
 Posted - 2008-02-14 : 22:25:56
|
| how to pass array of values in stored procedure.. |
|
|
SusanthaB
Starting Member
14 Posts |
Posted - 2008-02-15 : 00:09:07
|
| It is not possible to pass an array to stored procedure up to SQL Server 2005. But in SQL Sever 2008, you have a similar feature; there you can pass a variable table into a stored procedure. check below link.http://www.sqlservercentral.com/articles/News/3182/You achieve a similar objective by passing comma separated value into a stored procedure as a single string. Then get the table result set by passing comma separated string to table value function within the stored procedure.http://vyaskn.tripod.com/passing_arrays_to_stored_procedures.htm |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-02-15 : 02:07:53
|
| http://www.sommarskog.se/arrays-in-sql.htmlMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
array of values using stored procedure