SQL Server 2012-使用sp_msforeachdb(SQL Server 2012- Using sp_msforeachdb)

 我想只在某些特定的数据库上运行SELECT语句。 此查询返回数据库列表： 
 
DECLARE @OneWeekAgo DATETIME
SELECT @OneWeekAgo = DATEADD(week,-1,GETDATE())

select distinct DB_NAME(database_id) DatabaseName 
into #temp
from sys.dm_db_index_usage_stats
where DB_NAME(database_id) like 'TTT[_][a-z]%'
  and DB_NAME(database_id) not like '%test%' 
  and last_user_update > @OneWeekAgo
 
 现在返回所有这些数据库，我想运行一个简单的查询： 
 
SELECT * 
FROM TTT_Clients 
WHERE country like 'SWEDEN'
 
 我怎么做？ 我使用类似这样的东西在“IN（SELECT DISTINCT ...）”行中出错： 
 
exec sp_msforeachdb ' use [?] IF  ''?'' in (select distinct DB_NAME(database_id) DatabaseName 
                                            from sys.dm_db_index_usage_stats
                                            where DB_NAME(database_id) like  ''TTT[_][a-z]%'' 
                                              and DB_NAME(database_id) not like ''%test%'') 
BEGIN
    SELECT * FROM TTT_Clients WHERE country like ''SWEDEN''
END

I want to run a SELECT statement on only some specific databases. The list of databases is returned by this query:
 
DECLARE @OneWeekAgo DATETIME
SELECT @OneWeekAgo = DATEADD(week,-1,GETDATE())

select distinct DB_NAME(database_id) DatabaseName 
into #temp
from sys.dm_db_index_usage_stats
where DB_NAME(database_id) like 'TTT[_][a-z]%'
  and DB_NAME(database_id) not like '%test%' 
  and last_user_update > @OneWeekAgo
 
Now on all of these databases returned, I want to run a simple query:
 
SELECT * 
FROM TTT_Clients 
WHERE country like 'SWEDEN'
 
How do I do that? I get errors in the "IN (SELECT DISTINCT...)" line using something like this:
 
exec sp_msforeachdb ' use [?] IF  ''?'' in (select distinct DB_NAME(database_id) DatabaseName 
                                            from sys.dm_db_index_usage_stats
                                            where DB_NAME(database_id) like  ''TTT[_][a-z]%'' 
                                              and DB_NAME(database_id) not like ''%test%'') 
BEGIN
    SELECT * FROM TTT_Clients WHERE country like ''SWEDEN''
END

原文：https://stackoverflow.com/questions/29979576