22,210
社区成员
发帖
与我相关
我的任务
分享
set @sql1 = ' a,b,c '
set @sql2 = ' d,e,f '
exec('select' + @sql1 + @sql2 + 'from tablename order by a ')
set @sqlbegin = 'select'
set @sql1 = ' a,b,c '
set @sql2 = ' d,e,f '
set @sqlend = 'from tablename order by a '
exec(@sqlbegin + @sql1 + @sql2 + @sqlend )
set @sql1 = ' a,b,c '
set @sql2 = ' d,e,f '
exec('select' + @sql1 + ',' + @sql2 + 'from tablename order by a ')
--or
set @sqlbegin = 'select'
set @sql1 = ' a,b,c '
set @sql2 = ' d,e,f '
set @sqlend = 'from tablename order by a '
exec(@sqlbegin + @sql1 + ',' + @sql2 + @sqlend )
--最后执行的SQL都是同一语句,结果集完全相同!