--动态sql语句
declare @s nvarchar(4000)
set @s=''
select @s=@s+','+quotename(FieldName)
from Table1
order by ID
set @s=stuff(@s,1,1,'')
exec('select '+@s+' from Table2')
declare @s nvarchar(4000)
set @s=''
select @s=@s+','+quotename(FieldName)
from Table1
order by ID
set @s=stuff(@s,1,1,'')
exec('select '+@s+' from Table2')
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货