//题目1declare @num int ,@total bigintselect @num = 1, @total = 0 declare @sum1_10 int , @sum11_30 bigintselect @sum1_10 = 0, @sum11_30 = 0while @num <31begin if @num <11 set @sum1_10 = @sum1 展开
//题目1declare @num int ,@total bigintselect @num = 1, @total = 0 declare @sum1_10 int , @sum11_30 bigintselect @sum1_10 = 0, @sum11_30 = 0while @num <31begin if @num <11 set @sum1_10 = @sum1_10 + @num else set @sum11_30 = @sum11_30 + @num * @num set @num = @num + 1endWAITFOR DELAY '00:00:2'set @total = @sum1_10 + @sum11_30print '1-10的累加和+11-30的累加和='+ cast(@total as varchar)//题目2declare @num int ,@sum90_100 bigintselect @num = 1, @sum90_100 = 0while @num <101begin if @num >= 90 set @sum90_100 = @sum90_100 + @num set @num = @num + 1 if @num = 101 breakendprint '90-100的累加和='+ cast(@sum90_100 as varchar)//题目3declare @num int ,@sum1_80 bigintselect @num = 1, @sum1_80 = 0while @num <101begin if @num <= 81 set @sum1_80 = @sum1_80 + @num set @num = @num + 1 if @num = 81 begin print '1-80的累加和='+ cast(@sum1_80 as varchar) return endend//题目4declare @x intset @x = 1if @x = 1 print '0<x<2'else if @x = 2 print 'x>1'else if @x = 3 print 'x<4'//题目5declare @index int set @index = 50while @index <71begin if @index = 60 begin set @index = @index +1 continue end print '@index='+cast(@index as varchar) set @index = @index +1end 收起
