Hi,
Does anyone know how to create a stored procedure in sql server that accepts a recordset as input and then saves the recordset to a table (similar to the way that vb handles batch processing).
Thanks,
Patrick Nolan
Printable View
Hi,
Does anyone know how to create a stored procedure in sql server that accepts a recordset as input and then saves the recordset to a table (similar to the way that vb handles batch processing).
Thanks,
Patrick Nolan
Hi Nolan,
According to my knowledge you cannot do that (mean we cannot pass a Recordset object itself as a parameter to StoredProcedure). Because in SQL there is no datatype like Recordset or equivalent to that.
bpp
SQL server 2000 has a data type table, but this can't be passed from vb (or I haven't seen anyone do this). At SQL level, you can pass back and forth a table, but in VB you will need to write a routine to get the recordset in a table on the server.
Tom Cannaerts
[email protected]
Programming today is a race between software engineers striving to build bigger and better idot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook