Is it possible to reference temporary tables created by using a second SQL Query Analyzer session? My problem is that I have two SQL Query Analyzer windows running, the first one creating temporary table and the second runs SQL that try to reference those temp tables once created.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Referencing Temp tables created in another active session
- Thread starter avid1741
- Start date
From books on line:
"You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions.
Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name)."
"You can create local and global temporary tables. Local temporary tables are visible only in the current session; global temporary tables are visible to all sessions.
Prefix local temporary table names with single number sign (#table_name), and prefix global temporary table names with a double number sign (##table_name)."
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question