sql server while 循环

declare @sum bigint,@sql varchar(8000)declare @i int set @sum = 1 set @sql = ''set @i = 2 while(@i <= 20) begin set @sum = @i * @sum set @sql = @sql + ',sum(case when allscore between )'set @i = @i + 1 end print @sum print @sql