SQL Server

[uni]

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

[praveen b p]

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

[Cakkie]

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
slisse@planetinternet.be

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