34,575
社区成员
发帖
与我相关
我的任务
分享
declare @table varchar(100) ,@field varchar(100),@condition varchar(100)
declare mycur cursor
for
select query_table_name,query_table_colunm ,query_table_where
from tb
open mycur
fetch next from mycur into @table,@field,@condition
while @@fetch_status = 0
begin
declare @sql varchar(max)
set @sql = ''
set @sql = 'select '+@field +' from '+ @table+' where '+@condition
exec(@sql)
fetch next from mycur into @table,@field,@condition
end
close mycur
deallocate mycur
declare @sql varchar(8000)
select
@sql=isnull(@sql,'')
+'select '+query_table_colunm+' from '+query_table_name+' where '+query_table_where
from
tb
exec (@sql)