General information
Forum:
Microsoft SQL Server
Title:
Temporary Tables in Sql Server 7
Hi!,
I would like to know the way to verify the existence of a temporary table created locally by the current session.
I've tried querying tempdb.dbo.sysobjects, but when I do so I get all the temporary tables for the different sessions.
e.g.
I have two sessions A and B, in session A, I create a table with tmpX for name. Now in session B I have some code manipulating a table with the same name, but I'd like to create the table just the first time the code is executed, next executions I'd just want to manipulate the existing table, but is in those cases when I can't find out if the table has been created in the current session.
Any help will be appreciated.
Thanks in advance!.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only