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?