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 procedure
Madhivanan
Failing to plan is Planning to fail |
|
|
|
|
|
|
parameter as table column values