谁帮我？(100分)

W

Winder_handle

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-22

• #1

如何用程序判断SQLServer2000中某个数据库是否存在？
谢谢！！

 

S

snjat

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-22

• #2

查看sysdatabases表中记录就行了

 

U

ugvanxk

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-22

• #3

if exists(select * from sysobjects where name=tablename)

 

S

szdy

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-22

• #4

select '存在' where exists (select * from sysdatabases where name ='DBName')

 

W

Winder_handle

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-23

• #5

能说详细一点吗？我比较菜！

 

W

Winder_handle

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-23

• #6

解决了，谢谢你们！

 

W

Winder_handle

Unregistered / Unconfirmed

GUEST, unregistred user!

• 2002-05-23

• #7

多人接受答案了。