实现将一个正整数随机拆分为三个正整数-- 【叶子】

一、在sql中实现将一个正整数随机拆分为三个正整数

1、sql代码

declare @i int

set @i =100;--要拆分的正整数

declare @j int

set @j =round(rand()*@i+1.0,0)

declare @k int

select @k=round(rand()*(@i-@j)+1.0,0)

declare @table table(id int)

if(@j>0 and @k>0 and @i-@j-@k>0)

begin

insert into @table

select @j union all

select @k union all

select @i-@j-@k

select * from @table order by newid();

end

go 100

2、运行结果

/* 运行结果(部分)

id

-----------

77

6

17

(3 row(s) affected)

id

-----------

7

31

62

(3 row(s) affected)

id

-----------

29

66

5

(3 row(s) affected)

id

-----------

4

67

29

(3 row(s) affected)

id

-----------

37

32

31

(3 row(s) affected)

id

-----------

39

39

22

(3 row(s) affected)

id

-----------

64

22

14

(3 row(s) affected)

id

-----------

9

13

78

(3 row(s) affected)

id

-----------

10

62

28

(3 row(s) affected)

id

-----------

33

10

57

(3 row(s) affected)

*/