|
|
Posted by pinney.colton@gmail.com on 06/14/06 01:21
DickChristoph wrote:
> > EXECUTE sp_executesql @nxq
>
> What this does is creates a table in the scope of the EXECUTE and then table
> then goes away as soon as the EXECUTE is finished,
Wow. I was about to reply with "I don't believe you" b/c I have a
similar section of code just above it that, at first glance, does the
same thing. But in that case, the temporary table is being created
immediately before sp_executesql (b/c the # of columns is not unknown
to me).
Subtle difference - but I see it now. Thanks for opening my eyes.
Navigation:
[Reply to this message]
|