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 - 2000-12-23 : 20:09:17
|
Olivier writes "In a stored procedure you can insert several records in one instruction with a SQL instruction like this one:
INSERT INTO Table1
SELECT Field1, Field2, ... , Fieldn
FROM Table2
WHERE Logical Condition
But what if a recordset is first created and records are added client-side in a component or an ASP page. An example of this case would be data received from other sources which is first parsed before being saved to SQL server.
Is there a way to pass a recordset to a stored procedure so that it will save the entire recordset as a batch ?
Thanks,
Olivier." |
|
|
|
|
|
Can you pass a recordset to a stored procedure ?