网站导航设计模板:编写sql程序,求出1-100之和。
来源:百度文库 编辑:高校问答 时间:2024/07/19 00:33:24
DECLARE @iSum int
DECLARE @idx int
SET @iSum = 0
SET @idx = 1
WHILE @idx < 101
BEGIN
SET @iSum = @iSum + @idx
SET @idx = @idx + 1
END
PRINT @iSum
DECLARE @iSum int
DECLARE @idx int
SET @iSum = 0
SET @idx = 1
WHILE @idx < 101
BEGIN
SET @iSum = @iSum + @idx
SET @idx = @idx + 1
END
PRINT @iSum