USE statement in SQL 7 - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

USE statement in SQL 7

USE statement in SQL 7# Database - 数据库

g*o2001-06-19 07:06

1 楼

Question:
Can I declare a variable to hold databases name and then use
the USE statement to switch between databases? Thanks.
I tried following approach but it won't work.
/*********************************
DECLARE @DatabaseName sysname
SET @DatabaseName = 'pubs'
USE @DatabaseName
*********************************/
Please help!

a*a2001-06-19 07:06

2 楼

I don't think it's possible but I may be wrong too..
Can you use sp_defaultdb? what's your scenario?

【在 g******o 的大作中提到】

: Question:
: Can I declare a variable to hold databases name and then use
: the USE statement to switch between databases? Thanks.
: I tried following approach but it won't work.
: /*********************************
: DECLARE @DatabaseName sysname
: SET @DatabaseName = 'pubs'
: USE @DatabaseName
: *********************************/
: Please help!