Jesse Hersch (com) writes:
The temp table is only visible to the connection that creates it, so
the risk is not that considerable.
It is not really clear from your posting if you want to pass table data
from the client to a stored procedure or between stored procedures. In
the latter case, this arficle on my web site can give you some ideas:
If you want to pass data from client to an sproc, one alternative to
a temp table is to have a permanent table which is key by a sessionid.
We have over 20 and still counting in our database. In our case, the
sessionid can be positive, in which case we use spid, or negative
in which case it is a generated value. The negative numbers are good
when you use disconnected record sets.
Oh, no, you can structure your data as a string and unpack it as a
table with out dynamic SQL. Yet another article on my web site
discusses a whole bunch of methods:
Erland Sommarskog, SQL Server MVP, se
Books Online for SQL Server SP3 at