计算1--100之间偶数之和 RT如何使用T-SQL中的while写这个循环啊请会的朋友帮帮忙最好能运行出结果谢谢 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 declare @i as intdeclare @val as intset @i = 2set @val = 0while @i <= 200begin set @val = @val + @i set @i = @i + 2endprint @val/*10100*/ declare @i as intdeclare @val as intset @i = 2set @val = 0while @i <= 100begin set @val = @val + @i set @i = @i + 2endprint @val/*2550*/ DECLARE @num INT DECLARE @total intSET @num=100SET @total=0WHILE(@num>0)BEGINSET @total=@total+@numSET @num=@num-2ENDPRINT @total select sum(number) from master..spt_values where number %2=0 and type='p' AND number<=100--result/*----------- 2550(所影响的行数为 1 行)*/ declare @i int,@iCount intset @i=0set @iCount=0while @i<=100begin set @iCount=@iCount+@i set @i=@i+2endprint @iCount declare @i intdeclare @sum intset @i=1set @sum=0while @i<=100 begin if @i%2=0 begin set @sum=@sum+@i end set @i=@i+1endselect @sum declare @i int,@j intselect @i=1,@j=0while @i<=100begin select @j=@j+@i where @i%2=0 set @i=@i+1endselect @j/*-----------2550(1 行受影响)*/ 这个统计的求SQL语句怎么写? 如何写这样的存储过程? 求助高手 左外连接问题 合并问题,请大家指教~~谢谢 sql 多表查询问题 SQL2000速度变得好慢! '[microsoft][ODBC SQL SERVER DRIVER]超时已过期',请高手指教 求职!!!!!!!!!! 分开数据(在线,回答即给分) 求救!日期加减的问题 比较两句SQL有何不同 随机获取表里的一条数据
declare @val as int
set @i = 2
set @val = 0
while @i <= 200
begin
set @val = @val + @i
set @i = @i + 2
endprint @val/*
10100
*/
declare @val as int
set @i = 2
set @val = 0
while @i <= 100
begin
set @val = @val + @i
set @i = @i + 2
endprint @val/*
2550
*/
DECLARE @num INT
DECLARE @total int
SET @num=100
SET @total=0
WHILE(@num>0)
BEGIN
SET @total=@total+@num
SET @num=@num-2
END
PRINT @total
where number %2=0 and type='p' AND number<=100--result
/*-----------
2550(所影响的行数为 1 行)
*/
set @i=0
set @iCount=0
while @i<=100
begin
set @iCount=@iCount+@i
set @i=@i+2
end
print @iCount
declare @i int
declare @sum int
set @i=1
set @sum=0
while @i<=100
begin
if @i%2=0
begin
set @sum=@sum+@i
end set @i=@i+1
endselect @sum
select @i=1,@j=0
while @i<=100
begin
select @j=@j+@i where @i%2=0
set @i=@i+1
end
select @j
/*
-----------
2550(1 行受影响)
*/