create function f_avg(@学号 varchar(10)) return float as begin declare @avg float select @avg=avg(成绩) from tb where 学号=@学号 return @avg end
CREATE FUNCTION dbo.kc_aver(@课程代号 INT) RETURN DECIMAL(10,2) AS BEGIN DECLARE @re DECIMAL(10,2); SET @re=0; SELECT @re=AVG(成绩) FROM 选课表 WHERE 课程代号=@课程代号; RETURN @re; END GOSELECT dbo.kc_aver(XX)
return float
as
begin
declare @avg float
select @avg=avg(成绩) from tb where 学号=@学号
return @avg
end
RETURN DECIMAL(10,2)
AS
BEGIN
DECLARE @re DECIMAL(10,2);
SET @re=0;
SELECT @re=AVG(成绩)
FROM 选课表
WHERE 课程代号=@课程代号; RETURN @re;
END
GOSELECT dbo.kc_aver(XX)