如何通过exec方法返回值

[bobzhang]

如下例子所示：
能把exec @strsql执行以后的结果返回给@return_status吗？
declare @return_status int
declare @strsql varchar(200)
select @strsql='SELECT Count(Proins_ID) FROM RT_PigeProStat WHERE not ZQ_DM like ''000'' AND ProDef_ID=1 AND Proinst_Type is null AND Start_Date>= '+ '''2003-11-23 00:00:00''' + ' AND End_Date<= '+ '''2004-11-23 00:00:00'''
print @strsql
exec @strsql

[lalakid]

exec @return_status = @strsql

[WangZWang]

declare @return_status int
declare @strsql nvarchar(200)
set @strsql='SELECT @return_status=Count(Proins_ID)
FROM RT_PigeProStat WHERE not ZQ_DM like
''000'' AND ProDef_ID=1 AND Proinst_Type is null
AND Start_Date>=''2003-11-23 00:00:00''
AND End_Date<=''2004-11-23 00:00:00'''
print @strsql
execute sp_executesql @strsql,N'@return_status int out',@return_status out
print @return_status

[davorsuker39]

exec @return_status = @strsql

[iswear428]

declare @return int
declare @paramter varchar(200)
declare @strsql nvarchar(200)
set @paramter ='@i int out'
set @strsql='SELECT @i=Count(Proins_ID)
FROM RT_PigeProStat WHERE not ZQ_DM like
''000'' AND ProDef_ID=1 AND Proinst_Type is null
AND Start_Date>=''2003-11-23 00:00:00''
AND End_Date<=''2004-11-23 00:00:00'''
print @strsql
execute sp_executesql @strsql,@paramter,@return out
print @return