sql语句创建内存表怎么判断是不是已经存在这个内存表 ( 积分: 20 )

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #1

drop table if exists #TempTerm;
create table #TempTerm (
termid varchar(50),
[name] varchar(100),
member varchar(50)
)
这么写不对
该怎么写

 

S

songrun

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #2

if Exists(Select * from tempDB..sysobjects where left(Name,11) = '#ti_stat31_')
drop table [dbo].[#ti_stat31]

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #3

if Exists(Select * from Tempdb..sysobjects where left(Name,11) = '#TempTerm')
drop table [dbo].[#TempTerm]
drop table [dbo].[#TempTerm]
create table #TempTerm (
termid varchar(50),
[name] varchar(100),
member varchar(50)
)
这么写了还是过不去啊

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #4

If Object_Id('Tempdb.dbo.#TempTerm') Is Not Null
drop table [dbo].[#TempTerm];
create table #TempTerm (
termid varchar(50),
[name] varchar(100),
member varchar(50)
)

 

一

一份子

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #5

if Exists(Select * from Tempdb..sysobjects where left Name = '#TempTerm') then
drop table [dbo].[#TempTerm]

create table #TempTerm (
termid varchar(50),
[name] varchar(100),
member varchar(50)
)
)

 

T

themars

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #6

if Exists(Select * from Tempdb..sysobjects where id = object_id(
'Tempdb..#TempTerm')) then drop table #TempTerm

 

J

jialiguo

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2007-04-25

• #7

接受