使用SQL中的函数，也可以根据更新表的某些字段还要进行计算，下面就将为您介绍这种使用SQL中的函数替代游标的方法，供您参考，希望对您有所帮助。

CREATEFUNCTION[DBO].[FUN_RATE](@PARTIDINT,@ENIDINT,@SOURCEIDINT,@QUALITYIDINT,@COUNTINT) 
RETURNSFLOATAS 
BEGIN 
DECLARE@QXSFLOAT,@GFLOAT,@RATEFLOAT 
IF(@ENID=NULL)OR(@PARTID=NULL)OR(@SOURCEID=NULL)OR(@QUALITYID=NULL) 
BEGIN 
RETURN(0.0) 
END 
SELECT@QXS=ISNULL(XS,0)FROMTABLEQUALITYWHEREID=@QUALITYID 
SELECT@G=ISNULL(FRATE_G,0)FROMTABLEFAILURERATE 
WHERE(SUBKINDID=@PARTID)AND(ENID=@ENID)AND(DATASOURCEID=@SOURCEID)AND(((ISNULL(MINCOUNT,0)<=ISNULL(@COUNT,0))AND(ISNULL(MAXCOUNT,0)>=ISNULL(@COUNT,0))) 
OR(ISNULL(@COUNT,0)>ISNULL(MAXCOUNT,0))) 
SET@RATE=ISNULL(@QXS*@G,0) 
RETURN(@RATE) 
END 
调用函数的存储过程部分： 
CREATEPROCPROC_FAULTRATE 
@PARTIDINTEGER,@QUALITYIDINTEGER,@SOURCEIDINTEGER,@COUNTINTEGER,@ROIDINT,@GRADEINT,@RATEFLOAT=0OUTPUTAS 
BEGIN 
DECLARE 
@TASKIDINT 
SET@RATE=0.0 
SELECT@TASKID=ISNULL(TASKPROID,-1)FROMTABLERELATIONWHEREID=(SELECTPIDFROMTABLERELATIONWHEREID=@ROID) 
IF(@TASKID=-1)OR(@GRADE=1)BEGIN 
SET@RATE=0
RETURN 
END 
SELECT@RATE=SUM([DBO].[FUN_RATE](@PARTID,ENID,@SOURCEID,@QUALITYID,@COUNT)*ISNULL(WORKPERCENT,0)/100.0) 
FROMTABLETASKPHASE 
WHERETASKID=@TASKID 
END 
GO