Is there some way to pass multiple values (records) to a stored procedure
without saving them first in a temp. table?
Can we use an API cursor to solve this problem?
Tahir
Printable View
Is there some way to pass multiple values (records) to a stored procedure
without saving them first in a temp. table?
Can we use an API cursor to solve this problem?
Tahir
SQL Server does have a cursor datatype for passing cursors to stored procedures
but I've never tried it.
I believe the most common approach is to populate a temp. table.
-Mike
