--函数不支持动态SQL,用存储过程
解决方案 »
- 请解释下这句代码是什么意思?谢谢,尽量详细点!
- 同一服务器下跨数据库查询比较问题
- 关于SQL SEVER 2005的安装问题
- ===============请问大家DBF是什么格式?是数据库的全部信息还是数据库的其中表呢+++++++++++++++++++++
- winXP P + Sql Server 2000个人版的问题
- 请问两个float值相减的问题
- 高分相送!!!!!!!!!如何写这样的查询语句?
- 存储过程如何操作另一个数据库中的表
- 如何进行字段的列运算,比如求和?
- only fully keyset driven cursors can have "order by"、"group by"
- SQL server 2000同步
- 兄弟们帮忙哦,sql痛苦的表现
@ADKind VARCHAR(10)=NULL,
@TabName VARCHAR(10)=NULL,
@Field VARCHAR(10)=NULL,
@Condition VARCHAR(10)=NULL,
@Flag INTEGER==NULL,
@RETURN FLOAT output
AS
BEGIN
declare @fValue float
declare @strSQL VARCHAR
declare @iNIAN VARCHAR
declare @iYUE VARCHAR
declare @iRI VARCHAR
declare @iJZ VARCHAR(10)
SET @iNIAN=(select NIAN from pub_var where DKind=@ADKind)
SET @iYUE=(select YUE from pub_var where DKind=@ADKind)
SET @iRI=(select RI from pub_var where DKind=@ADKind)
SET @iJZ=(select JZ from pub_var where DKind=@ADKind)
--单机组月累计,条件为NIAN,YUE,RI,JZ 本年本月累计到目前日期为止
if @Flag=1 begin
SET @strSQL='select @tfValue=avg('+@Field+') from '+@TabName+' where JZ='+@iJZ+' and NIAN='+cast(@iNIAN AS VARCHAR)+'
and YUE='+cast(@iYUE AS VARCHAR)+' and RI>=1 and RI<='+cast(@iRI AS VARCHAR)+' and '+@Condition+'GROUP BY NIAN,YUE,JZ'
--EXECUTE('update tmp_value set value=select avg('+@Field+') from '+@TabName+' where JZ='+@iJZ+' and NIAN='+@iNIAN+'
-- and YUE='+@iYUE+' and RI>=1 and RI<='+@iRI+' and '+@Condition+'GROUP BY NIAN,YUE,JZ')
EXEC sp_executesql
@strSQL,
N'@tfValue int OUTPUT',
@tfValue=@fValue OUTPUT
end
select @RETURN=@fValue
END
select * from dbo.存储过程 where ...????
好象不可以吧