1+2+3 +...+100这种问题，首相想到的是用循环解决。代码如下
;declare @v_i int = 1,@v_sum int = 0
while @v_i <= 100
begin
set @v_sum = @v_sum + @v_i
set @v_i = @v_i + 1
end
print @v_sum
最近发现可以用with as特性同样可以解决
;with a(v) as(
select 1
union all
select v+1 from a where v+1<=100)
select sum(v) from a
