declare @t varchar(100)
declare @sql varchar(1000)
select @t = B1 from B where B2='1'
select @sql = 'select' + @t + ' from A'
exec(@sql)
declare @sql varchar(1000)
select @t = B1 from B where B2='1'
select @sql = 'select' + @t + ' from A'
exec(@sql)
select @s = b1 from b where b2 = '1'@s = 'select ' + @s + ' from a'
exec(@s)
create proc pr_query
@B2 varchar(10)
asdeclare @sql varchar(500)
select @sql='select '+B1+' from A' from B where B2=@B2
exec(@sql)
go
--调用
exec pr_query '1'