declare
@id int=1,
@maxid int,
@ku nvarchar(20),
@dbname nvarchar(50),
@sql nvarchar(max)
select @maxid=count(1) from (select row_number()over(order by companycode) as id ,* from Company) company
while @id<=@maxid
begin
select @dbname=dbname from (select row_number()over(order by companycode) as id ,* from Company) company
where id=@id
set @sql='
select top 1 * from '+@dbname+'..ojdt'
print @dbname
print @sql
set @id=@id+1
end
循环打印
最新推荐文章于 2022-11-23 14:52:27 发布