declare DB_Cursor cursor FOR
select name AS DB_NAME from master..sysdatabases where [name] NOT IN ('master','tempdb','model','msdb')
open DB_Cursor
DECLARE @DB_NAME varchar(50), @strSql varchar(1000), @DB_NAME_LIST varchar(4000)
set @DB_NAME_LIST = ''
fetch next from DB_Cursor INTO @DB_NAME
while(@@fetch_status=0)
BEGIN
set @strSql = 'Use [' + @DB_NAME + '] ';
set @strSql = @strSql + '
if exists (select * from sysobjects where id = object_id(N''[表名]'') and OBJECTPROPERTY(id, N''IsUserTable'') = 1) Begin
select ''' + @DB_NAME + ''' as 项目名称,* from 表名 where 条件 End
';
exec (@strSql)
set @DB_NAME_LIST = @DB_NAME_LIST + @strSql
--读取下一条记录
fetch next from DB_Cursor INTO @DB_NAME
END
close DB_Cursor
--释放游标
deallocate DB_Cursor
PRINT @DB_NAME_LIST