本文介绍了使用递归法及循环法实现特定数值分解的方法。通过递归调用自身函数和循环迭代处理的方式，实现了将一个整数分解为2的幂次方之和的功能，并返回了具体的分解结果。
--递归法
create function f_getnum(@i int)
returns @t table(r int)
as
begin
declare @n int
set @n = 1
while 2*@n<=@i
begin
set @n = @n * 2
end
insert @t select @n
set @n = @i - @n
if @n > 0
insert @t select r from f_getnum(@n)
return;
end
go
select * from f_getnum(10)
--循环法
alter function f_getnum (@i int)
returns @t table(r int)
as
begin
declare @n int
while @i > 0
begin
set @n = 1
while 2*@n<=@i
begin
set @n = @n * 2
end
insert @t select @n
set @i = @i - @n
end
return;
end
go
select * from f_getnum(10)
/*
r
-----------
8
2
(2 行受影响)
*/
http://topic.youkuaiyun.com/u/20090807/08/19f980a3-3830-4261-90ca-0f85ec628492.html?72858
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
