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 |
|
asilter
Starting Member
5 Posts |
 Posted - 2007-09-21 : 06:39:45
|
| can we define a stored procedure parameter which holds a table's column values?And can we loop in it in a stored procedure?If yes, could you give a little sql code sample?Thanx |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
asilter
Starting Member
5 Posts |
Posted - 2007-09-21 : 08:53:19
|
| no.int the example you sent, the passing parameter is like one string which holds values seperated by commas. what i want to learn is if sql server could support variables which are in format like recordsets?and if so, plz a little code sample. |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-09-24 : 02:24:30
|
| I dont think you can send parameter like Recordset. You need to replicate that method or use temporary table inside the procedureMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
parameter as table column values