DECLARE @Sql NVARCHAR(max)='' SELECT @Sql+=' UNION ALL SELECT * FROM '+QUOTENAME(NAME)+'..表名' FROM master.sys.databases WHERE name LIKE 'abc%' SET @Sql=STUFF(@Sql,1,10,'') PRINT @Sql
