内容摘要：复制CREATEFUNCTION[DBO].[FUN_GETTIME](@TASKPHASEIDINT) RETURNSFLOATAS BEGIN

复制CREATEFUNCTION [DBO].[FUN_GETTIME] (@TASKPHASEID INT)   RETURNSFLOATAS BEGIN DECLARE @TASKID INT,讲解据库   　　@HOURFLOAT,   　　@PERCENT FLOAT,   　　@RETURNFLOAT 　　IF @TASKPHASEID ISNULL BEGIN RETURN(0.0)   END SELECT @TASKID=TASKID,@PERCENT=ISNULL(WORKPERCENT,0)/100   FROM TABLETASKPHASE   WHERE ID=@TASKPHASEID   SELECT @HOUR=ISNULL(TASKTIME,0) FROM TABLETASK   WHERE ID=@TASKID   SET @RETURN=@HOUR*@PERCENT   RETURN (@RETURN)   END 1.2.3.4.5.6.7.8.9.10.11.12.13.14.15.16.17.18.19.