create function average.sql

来自「在学习SQL Server过程中整理的T-SQL语句」· SQL 代码 · 共 18 行

use test
go

create function average(@cnum char(20)) returns int 
as
begin
    declare @aver int
    select @aver=
             (
               select avg(score)
                      from xs_kc
                      where course=@cnum
                         group by course
                  
                  )
    return @aver
end
go