create function average(@stuno as char(10))
returns real
begin
declare @aver int
select @aver=(select avg(score) from choice where s_no=@stuno)
return @aver
end
create function average(@stuno as char(10)) returns real begin declare @aver int select @aver=(select avg(score) from choice where s_no=@stuno) return @aver end 我是新手,现在想问的就是,returns real中real是返回值的数据类型,在这里就是指@aver的数据类型么?一开始不是定义为int的吗,怎么就直接变real类型了呢?
[Quote=引用楼主 guangguang2007 的帖子:]
create function average(@stuno as char(10))
returns real
begin
declare @aver int
select @aver=(select avg(score) from choice where s_no=@stuno)
return @aver
end
create function average(@stuno as char(10))
returns real --決定返回類型
begin
declare @aver int
select @aver=(select avg(score) from choice where s_no=@stuno)
return @aver
end