declare @AAAAA varchar(1000)
declare @s varchar(8000)
set @s = 'select A,B,C,(select D from TABLE '+@AAAAA+') from ....'
set @@AAAAA = 'where 1=1'
exec (@s)
declare @s varchar(8000)
set @s = 'select A,B,C,(select D from TABLE '+@AAAAA+') from ....'
set @@AAAAA = 'where 1=1'
exec (@s)
exec('slelect A,B,C,(select D from TABLE '+@AAAAA+') from ....')
[交流]动态SQL语句
set @tb='AAAAA'exec('slelect A,B,C,(select D from '+@tb+') from ....')