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 |
|
iamsmahd
Yak Posting Veteran
55 Posts |
 Posted - 2005-02-06 : 06:32:48
|
| Hi all.Can I Have a stored procedure which its input is a Recordset (Table) ?If yes, could you please help me?Thank you very muchSonia |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-02-06 : 09:34:47
|
| Not as a table variable i n a parameter if that's what you mean.There are a number of ways of doing it though.Pass a csv string.Create an xml doc and pass that.BCP out the data and use bulk insert into a temp table in the SP,Creare a temp table populate it and access it in the SP.Pass the table name and use dynamic sql in the sp.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
A stored procedure which has a table as its input