在SQL中如何知道当前所运行的数据库的名字?

[kewin_007]

在SQL中如何知道当前所运行的数据库的名字?(语法越详细越好!)

[liangCK]

db_name()

[zg182]

SELECT DB_NAME()

[-狙击手-]

declare @s varchar(10)

select @s = db_name()

exec master..sp_helpdb  @s

[-狙击手-]

name                                                                                                                             db_size       owner                                                                                                                            dbid   created     status                                                                                                                                                                                                                                                           compatibility_level 
-------------------------------------------------------------------------------------------------------------------------------- ------------- -------------------------------------------------------------------------------------------------------------------------------- ------ ----------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------- 
CSDN_TEST                                                                                                                              7.56 MB sa                                                                                                                               8      09 21 2007  Status=ONLINE, Updateability=READ_WRITE, UserAccess=MULTI_USER, Recovery=SIMPLE, Version=539, Collation=Chinese_PRC_CI_AS, SQLSortOrder=0, IsAutoShrink, IsTornPageDetectionEnabled, IsAutoCreateStatistics, IsAutoUpdateStatistics                              80

 
name                                                                                                                             fileid filename                                                                                                                                                                                                                                                         filegroup                                                                                                                        size               maxsize            growth             usage     
-------------------------------------------------------------------------------------------------------------------------------- ------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ------------------ ------------------ ------------------ --------- 
csdn_test_Data                                                                                                                   1      C:\Program Files\Microsoft SQL Server\MSSQL\Data\CSDN_TEST_data.mdf                                                                                                                                                                                              PRIMARY                                                                                                                          6720 KB            Unlimited          10%                data only
csdn_test_Log                                                                                                                    2      C:\Program Files\Microsoft SQL Server\MSSQL\Data\CSDN_TEST_log.ldf                                                                                                                                                                                               NULL                                                                                                                             1024 KB            Unlimited          10%                log only

[rouqu]

没必要重复了

[w2jc]

学习一下

[hui_hui_2007]

use pubs
select db_name()

-------------------------------------------------------------------------------------------------------------------------------- 
pubs

（所影响的行数为 1 行）