使用T-SQL程式設計求1到20中奇數的積
uj5u.com熱心網友回復：
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 行受影響)
*/
uj5u.com熱心網友回復：
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
uj5u.com熱心網友回復：
怎么感徑訓過個帖子呢。https://bbs.csdn.net/topics/392729890
uj5u.com熱心網友回復：
select power(2,sum(log(number,2)))from master.dbo.spt_values
where type='P'
and number between 1 and 20
and number%2!=0
/*
x
654729075
*/
uj5u.com熱心網友回復：
declare @i intdeclare @sac int
set @i=1
set @sac=1
while @i<=20
begin
if @i%2=1
set @sac=@sac*@i
set @i=@i+1
end
print @sac
轉載請註明出處，本文鏈接：https://www.uj5u.com/shujuku/146857.html
標籤：疑難問題