Very Computer

Hi there,

Wondering if someone could answer a simple question for
me (at least I think it is simple).

Is a table variable global only to a single instance of a
proc being run?  Lets say client app A and client app B
both call the same stored proc at the same time.  Will
they share the same table variable (each storing info in
only one table variable) or will they each have their own
table variable that holds each persons info seperately?

I would think each would have it's own, but the way my
app is responding, it sure seems like they are sharing
it.  Any hints on how to seperate the two if they are in
fact sharing it?

Thanks

Scope of table variables is local to the procedure or batch that created it,
just like normal variables. For more information on table variables check
out this KB article:
http://support.microsoft.com/default.aspx?scid=kb;en-us;305977

--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm

Hi there,

Wondering if someone could answer a simple question for
me (at least I think it is simple).

Is a table variable global only to a single instance of a
proc being run?  Lets say client app A and client app B
both call the same stored proc at the same time.  Will
they share the same table variable (each storing info in
only one table variable) or will they each have their own
table variable that holds each persons info seperately?

I would think each would have it's own, but the way my
app is responding, it sure seems like they are sharing
it.  Any hints on how to seperate the two if they are in
fact sharing it?

Thanks