microsoft.public.sqlserver.server

Author

table temporary

betty

2002-11-21, 5:23 am

Hi

I create table with command select * into #x from <tablename>, can't tried
check table '#x' exists in my table?

thank's
betty

Vishal Parkar

2002-11-21, 5:23 am

To check whether table exists

IF object_id('tempdb..#x') is not null
print 'table exists'
Else
print 'table does not exists'

To select all rows from table fire following query.

select * from #x

--Vishal

>-----Original Message-----
>Hi
>
>I create table with command select * into #x from
<tablename>, can't tried
>check table '#x' exists in my table?
>
>thank's
>betty
>
>
>
>.
>

Sponsored Links