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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-01-14 : 08:43:16
|
| Raja writes "Hi,I want to send a VB recordset to stored procedure's parameter. Its possible? If its possible then, What is the data type use for that parameter? I think Cursor data type.send me a solution with example of that.Thanks" |
|
|
andre
Constraint Violating Yak Guru
259 Posts |
Posted - 2002-01-14 : 10:24:53
|
| I don't believe you can do this. However, you do have some options:1) Convert the recordset into a delimited string and pass it to the stored procedure2) Convert the recordset into a tab-delimited text file and have the stored procedure BULK INSERT the data into a temporary table3) Have the VB program insert the data into a global temporary table so the stored procedure can access the data |
 |
|
|
|
|
|
How to send VB recordset to Stored procedure