--
不用临时表,获取动态SQL的返回值
declare @R varchar( 10),
@Return varchar( 10),
@s nvarchar( 1000)
set @R = ' 10 '
set @s = ' select @Return= '' 2011- '' + ''' + @R + ''''
Exec sp_executesql @s,N ' @Return varchar(10) output ', @Return output
select @Return