æ°ååºè¯¥æä¹å¼å¢ï¼ï¼è¦åæä¸ä¸ªå½æ°ï¼å¯ä»¥éç¨äºå个æ°åãä¸æ¯ä¸ªæ¥è¯¢è¯å¥
追çç¨å½æ°åå§
create function a
returns float
as
declare @grade float
begin
select student_no,@grade=sum(grade) from student group by student_no
retrun @grade
end
é£æè¿æ³é®ä¸ä¸ï¼æ¯å«æ±ä¸ä¸ªæ°åçåï¼é£åºè¯¥æä¹æ¹å¢ï¼æ°åä¾å¦ï¼12 34 54 56 2 3 45 76 æ±12å°45çå ¨é¨æ°åä¹åã
追çalter function a_aa()
returns float
as
begin
declare @a int
declare @sum int
set @a=12
set @sum=0
while @a<=45
begin
set @sum=@sum+@a
set @a=@a+1
end
return @sum
end
æ§è¡ select dbo.a_aa()
ç»æ:969
这个我也懂,是要写成函数的!例如有一个数列:23 45 5 6 7 8 95 56叫你现在写出一个函数来计算23到95的全部和!!!