利用算术（加减乘除）的方法实现从1到9计算等于100

原贴地址：http://topic.csdn.net/u/20100414/13/01a10c02-8230-4f0b-89d1-e0a51a64a97c.html?seed=1728387417

123456789
这九个按顺序排列的数，要求在它们之间插入若干个+，-，*，/ ，
使其结果正好等于100如： 1*2*3*4+5+6+7*8+9=100  

 

--------------------------------------------------------------------------

--  Author : htl258(Tony)

--  Date   : 2010-04-19 01:05:31

--  Version:Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86)

--          Jul  9 2008 14:43:34

--          Copyright (c) 1988-2008 Microsoft Corporation

--          Developer Edition on Windows NT 5.1 <X86> (Build 2600: Service Pack 3)

--------------------------------------------------------------------------

--游标法

SET NOCOUNT ON

DECLARE @T TABLE(R NVARCHAR(1))

INSERT @T SELECT '+'

UNION ALL SELECT '-'

UNION ALL SELECT '*'

UNION ALL SELECT '/'

DECLARE @S NVARCHAR(50),@I DEC(28,10)

DECLARE @R TABLE(RESULT NVARCHAR(30))

DECLARE C CURSOR FOR

    SELECT 'SELECT @I=1.'+A.R+'2.'+B.R+'3.'+C.R+'4.'

       +D.R+'5.'+E.R+'6.'+F.R+'7.'+G.R+'8.'+H.R+'9.'

    FROM @T A,@T B,@T C,@T D,@T E,@T F,@T G,@T H

OPEN C

FETCH C INTO @S

WHILE @@FETCH_STATUS=0

BEGIN

    EXEC SP_EXECUTESQL @S,N'@I DEC(28,10) OUT',@I OUT

    IF CEILING(@I)=100 AND FLOOR(@I)=100

    INSERT @R SELECT REPLACE(STUFF(@S,1,CHARINDEX('=',@S),''),'.','')

    FETCH C INTO @S

END

CLOSE C

DEALLOCATE C

SET NOCOUNT OFF

SELECT * FROM @R

/*

RESULT

------------------------------

1+2+3+4+5+6+7+8*9

1*2*3+4+5+6+7+8*9

1-2*3+4*5+6+7+8*9

1+2*3+4*5-6+7+8*9

1-2*3-4+5*6+7+8*9

1-2*3-4-5+6*7+8*9

1+2+3-4*5+6*7+8*9

1*2*3-4*5+6*7+8*9

1*2*3*4+5+6+7*8+9

1*2*3*4+5+6-7+8*9

1+2-3*4+5*6+7+8*9

1+2-3*4-5+6*7+8*9

1-2+3*4*5+6*7+8-9

1-2+3*4*5-6+7*8-9

1+2*3*4*5/6+7+8*9

 

(15 行受影响)

*/

 

--循环法 :原著 happycell188(喜喜) 改编完善: htl258(Tony)

set nocount on

declare @result nvarchar(50),@temp_int dec(28,10),@str nvarchar(5),

    @i1 int,@str1 char(1),

    @i2 int,@str2 char(1),

    @i3 int,@str3 char(1),

    @i4 int,@str4 char(1),

    @i5 int,@str5 char(1),

    @i6 int,@str6 char(1),

    @i7 int,@str7 char(1),

    @i8 int,@str8 char(1)

declare @temp_tb table(result nvarchar(30))

--赋值

select @str='+/-*',@i1=1,@i2=1,@i3=1,@i4=1,@i5=1,@i6=1,@i7=1,@i8=1

--函数主体

while(@i1<5)

begin

    while(@i2<5)

    begin

        while(@i3<5)

        begin

            while(@i4<5)

            begin

                while(@i5<5)

                begin

                    while(@i6<5)

                    begin

                        while(@i7<5)

                        begin

                            while(@i8<5)

                            begin

                                select

                                @str1=substring(@str,@i1,1),

                                @str2=substring(@str,@i2,1),

                                @str3=substring(@str,@i3,1),

                                @str4=substring(@str,@i4,1),

                                @str5=substring(@str,@i5,1),

                                @str6=substring(@str,@i6,1),

                                @str7=substring(@str,@i7,1),

                                @str8=substring(@str,@i8,1)

                                select @result='select @a=1.'+@str1+'2.'

                                +@str2+'3.'+@str3+'4.'+@str4+'5.'

                                +@str5+'6.'+@str6+'7.'+@str7+'8.'+@str8+'9.'

                                exec sp_executesql @result,

                                N'@a dec(28,10) output',@temp_int output

                                if floor(@temp_int)=100 and ceiling(@temp_int)=100

                                begin

                                    insert into @temp_tb(result)

                                   select right(replace(@result,'.',''),17)

                                end

                                select @i8=@i8+1

                            end

                        select @i7=@i7+1,@i8=1

                        end

                    select @i6=@i6+1,@i7=1,@i8=1

                    end

                select @i5=@i5+1,@i6=1,@i7=1,@i8=1

                end

            select @i4=@i4+1,@i5=1,@i6=1,@i7=1,@i8=1

            end

        select @i3=@i3+1,@i4=1,@i5=1,@i6=1,@i7=1,@i8=1

        end

    select @i2=@i2+1,@i3=1,@i4=1,@i5=1,@i6=1,@i7=1,@i8=1

    end

select @i1=@i1+1,@i2=1,@i3=1,@i4=1,@i5=1,@i6=1,@i7=1,@i8=1

end

set nocount off

--获取结果

select result from @temp_tb

/*

result

------------------------------

1+2+3+4+5+6+7+8*9

1+2+3-4*5+6*7+8*9

1+2-3*4+5*6+7+8*9

1+2-3*4-5+6*7+8*9

1+2*3+4*5-6+7+8*9

1+2*3*4*5/6+7+8*9

1-2+3*4*5+6*7+8-9

1-2+3*4*5-6+7*8-9

1-2*3+4*5+6+7+8*9

1-2*3-4+5*6+7+8*9

1-2*3-4-5+6*7+8*9

1*2*3+4+5+6+7+8*9

1*2*3-4*5+6*7+8*9

1*2*3*4+5+6+7*8+9

1*2*3*4+5+6-7+8*9

 

(15 行受影响)

*/