Question

1/1*1+2*2+3*3.......n*n用sql sevrer 2005如何 编程?

Answer 1

declare @n int
declare @i int
declare @value int
set @value=0
set @n=6
set @i=1
while(@i<=@n)
begin
set @value=@value+@i*@i
set @i=@i+1
end;
select @value