转自:http://www./?p=10739 declare @maomao365 varchar(1000) set @maomao365 ='sqlserver,blog,other'; ---将逗号替换为 'as n union all select ' set @maomao365 = REPLACE(@maomao365,',', ''' as n union all select ''' ); ---在字符串前面加上select 和单引号 ,后面也加上单引号 set @maomao365 =' select '''+ @maomao365 + ''''; print @maomao365 exec (@maomao365)
|
|