Good Day!
I would like to know how to pass an entire table generated from a stored procedure which will not require the use of a global temporary table.
I tried doing it with a normal temporary table but when I issue an INSERT, DELETE, or UPDATE statement succeedingly before a SELECT statement I get no results in VB though In SQL SERVER I can see the the result of the SELECT statement. I would like to eliminate the use of Global Temporary Tables for there will be a minumum of 100 users that will be connecting to the server.
Thank you.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement