34,576
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE #TEST(SHUZI INT)
declare @A int,
@B INT
SET @A=1
SET @B=100
PRINT @A
WHILE @A<=@B
BEGIN
INSERT INTO #TEST VALUES(@A)
SET @A=@A+1
END
SELECT * FROM #TEST
SELECT sum(SHUZI) FROM #TEST
create proc p_jisuan @A int,@B int
as
declare
@ssum int
SET @A=1
SET @B=100
set @ssum=0
PRINT @A
WHILE @A<=@B
BEGIN
set @ssum=@ssum+@a
SET @A=@A+1
END
print @ssum
select @ssum
exec p_jisuan 1,100
--CREATE TABLE #TEST(SHUZI INT)
--
--declare @A int,
-- @B INT
--SET @A=1
--SET @B=100
--PRINT @A
--WHILE @A<=@B
-- BEGIN
--INSERT INTO #TEST VALUES(@A)
--SET @A=@A+1
--END
--
--SELECT * FROM #TEST
--SELECT sum(SHUZI) FROM #TEST
declare @B INT
SET @B=100
;WITH c AS(
SELECT 1 AS Row
UNION ALL
SELECT Row+1 AS Row FROM c
WHERE c.Row<@B
)
SELECT SUM(Row) FROM c
;with t as(
select a=1
union all
select a=t.a+1 from t
where t.a<100
) select * from t option(maxrecursion 0)
-- 求和的话这句改成 select SUM(a) from t option(maxrecursion 0)
declare @A int,
@B INT,
@Sum int
SET @A=1
SET @B=100
set @sum=0
PRINT @A
WHILE @A<=@B
BEGIN
SET @A=@A+1
SET @Sum=@Sum+@A
END
SELECT @Sum
DECLARE @A INT
DECLARE @Total INT
SET @A = 1
SET @Total = 0
WHILE @A < 101
BEGIN
SET @Total = @Total + @A
SET @A = @A + 1
END
SELECT @Total
declare @A int,
@B INT,
@ssum int
SET @A=1
SET @B=100
set @ssum=0
PRINT @A
WHILE @A<=@B
BEGIN
set @ssum=@ssum+@a
SET @A=@A+1
END
print @ssum