请问怎么查询所有的数据库的名称（不包括系统数据库）

[yingoing]

在线 等

[yingoing]

帮帮吗

[喜-喜]

Select   name   from   master..sysdatabases     where   name   not   in('master','model','msdb','tempdb','northwind','pubs') 

[东那个升]

select * from master..sysdatabases
where sid!=0x01

[--小F--]

--2005
select
  *
from
  sys.databases
where
  name not in('master','model','msdb',tempdb')

[--小F--]

--2005
select
  *
from
  sys.databases
where
  name not in('master','model','msdb','tempdb')

[htl258_Tony]

[Quote=引用 2 楼 happycell188 的回复:]
SQL code
Select name from master..sysdatabases where name not in('master','model','msdb','tempdb','northwind','pubs')
[/Quote]..

[yhtapmys]

[Quote=引用 2 楼 happycell188 的回复:]
SQL code
Select name from master..sysdatabases where name not in('master','model','msdb','tempdb','northwind','pubs')
[/Quote]

UP
2000的

[黄_瓜]

[Quote=引用 3 楼 ldslove 的回复:]
SQL code
select * from master..sysdatabases
where sid!=0x01
[/Quote]
up

[htl258_Tony]

[Quote=引用 3 楼 ldslove 的回复:]
SQL code
select * from master..sysdatabases
where sid!=0x01
[/Quote]

SQL2008 下所有的SID都是0x01

[东那个升]

select @@version


select name from master..sysdatabases
where sid!=0x01


----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
Microsoft SQL Server 2008 R2 (CTP) - 10.50.1352.12 (Intel X86) 
	Oct 30 2009 18:22:17 
	Copyright (c) Microsoft Corporation
	Enterprise Evaluation Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)


(1 行受影响)

name
--------------------------------------------------------------------------------------------------------------------------------
test
test123
Northwind

(3 行受影响)

[yingoing]

[Quote=引用 3 楼 ldslove 的回复:]
SQL code
select * from master..sysdatabases
where sid!=0x01
[/Quote]
这个好像不行 我是SQL 2005

[yingoing]

还有什么跟简单方法吗

[东那个升]

select * from sys.databases
where database_id>4

其实这样也可以的。

[v1ctory1216]

sp_helpdb

[htl258_Tony]

[Quote=引用 12 楼 yingoing 的回复:]
还有什么跟简单方法吗
[/Quote]
就一个查询语句,怎么查都是简单的.