Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Da_Retina
Posting Yak Master
109 Posts |
 Posted - 2001-09-18 : 06:52:47
|
| Hi.Thanks in Advance.I want to create temp tables with random names. What I am doing is generating the name randomly then :SET @SelectStr = 'Select * into ' + @RandomTableName + ' from SomeTable'EXECUTE sp_executesql @SelectStrMy problem is that I can not see the temp table when I initiate the name with a #..but i am able to see it when i initiate it with ##. What could be possibly the reason? and can anyone elaborate on the scope of TEMP tables and thier context!Thanks Again |
|
|
|
|
|
TEMP TABLES