EXEC('DECLARE @PREVALUE NUMERIC(20,4);
SELECT TOP 1 @PREVALUE='+@FIELD+
' FROM '+@TABLENAME+
' WHERE
REPORTDATE<'''+@REPORTDATE+''' AND
COMPANYCODE='''+@COMPANYCODE+
''' AND ('+@STYLE+'=11 or '+@STYLE+'=13)
ORDER BY REPORTDATE DESC,'+@STYLE+' DESC;
')在上面的动态SQL中,@PREVALUE 的值已经改变,
我怎么能得到改变后@PREVALUE的值?
SELECT TOP 1 @PREVALUE='+@FIELD+
' FROM '+@TABLENAME+
' WHERE
REPORTDATE<'''+@REPORTDATE+''' AND
COMPANYCODE='''+@COMPANYCODE+
''' AND ('+@STYLE+'=11 or '+@STYLE+'=13)
ORDER BY REPORTDATE DESC,'+@STYLE+' DESC;
')在上面的动态SQL中,@PREVALUE 的值已经改变,
我怎么能得到改变后@PREVALUE的值?
declare @n int
set @s=N'select @i=1'
exec sp_executesql @s,N'@i int out',@n out
select @n自己照着改.