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

Question

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

Answer 1

declare @s varchar(10)select @s = db_name()exec master..sp_helpdb  @s

Answer 2

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

Answer 3

use pubs
select db_name()-------------------------------------------------------------------------------------------------------------------------------- 
pubs（所影响的行数为 1 行）