新建 文本文档.txt

来自「一般的数据库系统」· 文本 代码 · 共 11 行

CREATE FUNCTION  dbo.average(@cname varchar(20))  
RETURNS  int  AS  
BEGIN 
  declare   @aver int
  select @aver=(select avg(cj)
  from xs_kc join kc on xs_kc.kch=kc.kch
  where kcm=@cname 
  group by  xs_kc.kch)
 RETURN  @aver
  
END