SQL-sever

[人间值得未来可期]

SQL-sever输出1到20中奇数的积？

[卖水果的net]

declare @sum int = 1;
declare @n int = 1;
while @n <= 20
begin
	set @sum = @sum * @n
	set @n = @n + 2
end
print 'result = ' + cast(@sum as varchar(100))
go


result = 654729075

[ダ雨夹雪リ]

楼上的是正解,这样也对
DECLARE @A INT=1
SELECT @A=@A* number FROM
master.dbo.spt_values WHERE type='P' AND number%2=1 AND number<20
SELECT @A

[唐诗三百首]

declare @x int
 
select @x=isnull(@x,1)*number
 from master.dbo.spt_values
 where type='P'
 and number between 1 and 20
 and number%2!=0
 
select @x 'x'
 
/*
x
-----------
654729075
 
(1 行受影响)
*/