I wonder what the difference is between #temp_table and the user. # temp_table
create table
( id integer null);
select * from
select * from sysobjects where name = '#temp_table'
- close my client
select * from
create table user.
( id integer null);
select * from user.
select * from sysobjects where name = '#temp_table'
- close my client
select * from sysobjects where name = '#temp_table'
My main question is why
select * from sysobjects where name = '#temp_table'
returns nothing with the user.
select * from sysobjects where name = '#temp_table'
returns information.
source
share