DECLARE @command varchar(1000)
SELECT @command = 'IF ''?'' NOT IN(''master'', ''model'', ''msdb'', ''tempdb'') BEGIN USE ? EXEC(''select * from sys.database_files'') END'
EXEC sp_MSforeachdb @command
sp_MSforeachdb用法 (遍历数据库)
最新推荐文章于 2024-04-02 13:22:39 发布