怎样使用T-SQL语句从大到小输出九九乘法表

急急急

举报该文章

相关建议 2014-11-18

从小到大

declare @test table(c1 varchar(50),c2 varchar(50),c3 varchar(50),c4 varchar(50),c5 varchar(50),c6 varchar(50),c7 varchar(50),c8 varchar(50),c9 varchar(50))
declare @i int = 1
while(@i <= 9)
  begin
      insert into @test select case when (1 <= @i) then CONVERT(varchar(50),@i) + ' * 1 = ' + CONVERT(varchar(50),@i*1) else '' end,
                               case when (2 <= @i) then CONVERT(varchar(50),@i) + ' * 2 = ' + CONVERT(varchar(50),@i*2) else '' end,
                               case when (3 <= @i) then CONVERT(varchar(50),@i) + ' * 3 = ' + CONVERT(varchar(50),@i*3) else '' end,
                               case when (4 <= @i) then CONVERT(varchar(50),@i) + ' * 4 = ' + CONVERT(varchar(50),@i*4) else '' end,
                               case when (5 <= @i) then CONVERT(varchar(50),@i) + ' * 5 = ' + CONVERT(varchar(50),@i*5) else '' end,
                               case when (6 <= @i) then CONVERT(varchar(50),@i) + ' * 6 = ' + CONVERT(varchar(50),@i*6) else '' end,
                               case when (7 <= @i) then CONVERT(varchar(50),@i) + ' * 7 = ' + CONVERT(varchar(50),@i*7) else '' end,
                               case when (8 <= @i) then CONVERT(varchar(50),@i) + ' * 8 = ' + CONVERT(varchar(50),@i*8) else '' end,
                               case when (9 <= @i) then CONVERT(varchar(50),@i) + ' * 9 = ' + CONVERT(varchar(50),@i*9) else '' end
      set @i = @i + 1
  end

select * from @test

c1 c2 c3 c4 c5 c6 c7 c8 c9
1 * 1 = 1
2 * 1 = 2 2 * 2 = 4
3 * 1 = 3 3 * 2 = 6 3 * 3 = 9
4 * 1 = 4 4 * 2 = 8 4 * 3 = 12 4 * 4 = 16
5 * 1 = 5 5 * 2 = 10 5 * 3 = 15 5 * 4 = 20 5 * 5 = 25
6 * 1 = 6 6 * 2 = 12 6 * 3 = 18 6 * 4 = 24 6 * 5 = 30 6 * 6 = 36
7 * 1 = 7 7 * 2 = 14 7 * 3 = 21 7 * 4 = 28 7 * 5 = 35 7 * 6 = 42 7 * 7 = 49
8 * 1 = 8 8 * 2 = 16 8 * 3 = 24 8 * 4 = 32 8 * 5 = 40 8 * 6 = 48 8 * 7 = 56 8 * 8 = 64
9 * 1 = 9 9 * 2 = 18 9 * 3 = 27 9 * 4 = 36 9 * 5 = 45 9 * 6 = 54 9 * 7 = 63 9 * 8 = 72 9 * 9 = 81

从大到小

declare @test table(c1 varchar(50),c2 varchar(50),c3 varchar(50),c4 varchar(50),c5 varchar(50),c6 varchar(50),c7 varchar(50),c8 varchar(50),c9 varchar(50))
declare @i int = 9
while(@i >= 1)
  begin
      insert into @test select case when (1 <= @i) then CONVERT(varchar(50),@i) + ' * 1 = ' + CONVERT(varchar(50),@i*1) else '' end,
                               case when (2 <= @i) then CONVERT(varchar(50),@i) + ' * 2 = ' + CONVERT(varchar(50),@i*2) else '' end,
                               case when (3 <= @i) then CONVERT(varchar(50),@i) + ' * 3 = ' + CONVERT(varchar(50),@i*3) else '' end,
                               case when (4 <= @i) then CONVERT(varchar(50),@i) + ' * 4 = ' + CONVERT(varchar(50),@i*4) else '' end,
                               case when (5 <= @i) then CONVERT(varchar(50),@i) + ' * 5 = ' + CONVERT(varchar(50),@i*5) else '' end,
                               case when (6 <= @i) then CONVERT(varchar(50),@i) + ' * 6 = ' + CONVERT(varchar(50),@i*6) else '' end,
                               case when (7 <= @i) then CONVERT(varchar(50),@i) + ' * 7 = ' + CONVERT(varchar(50),@i*7) else '' end,
                               case when (8 <= @i) then CONVERT(varchar(50),@i) + ' * 8 = ' + CONVERT(varchar(50),@i*8) else '' end,
                               case when (9 <= @i) then CONVERT(varchar(50),@i) + ' * 9 = ' + CONVERT(varchar(50),@i*9) else '' end
      set @i = @i - 1
  end

select * from @test

c1 c2 c3 c4 c5 c6 c7 c8 c9
9 * 1 = 9 9 * 2 = 18 9 * 3 = 27 9 * 4 = 36 9 * 5 = 45 9 * 6 = 54 9 * 7 = 63 9 * 8 = 72 9 * 9 = 81
8 * 1 = 8 8 * 2 = 16 8 * 3 = 24 8 * 4 = 32 8 * 5 = 40 8 * 6 = 48 8 * 7 = 56 8 * 8 = 64
7 * 1 = 7 7 * 2 = 14 7 * 3 = 21 7 * 4 = 28 7 * 5 = 35 7 * 6 = 42 7 * 7 = 49
6 * 1 = 6 6 * 2 = 12 6 * 3 = 18 6 * 4 = 24 6 * 5 = 30 6 * 6 = 36
5 * 1 = 5 5 * 2 = 10 5 * 3 = 15 5 * 4 = 20 5 * 5 = 25
4 * 1 = 4 4 * 2 = 8 4 * 3 = 12 4 * 4 = 16
3 * 1 = 3 3 * 2 = 6 3 * 3 = 9
2 * 1 = 2 2 * 2 = 4
1 * 1 = 1

温馨提示：内容为网友见解，仅供参考

当前网址：https://aolonic.com/aa/ak3da4g4wa43g3wa4aw.html

其他看法

第1个回答 2014-11-18

declare @i smallint,@j smallint,@str varchar(100)
set @i=1
while @i<=9
begin
select @j=1,@str=''
while @j<=@i
select @str=@str
+cast(@j as char(1))
+'*'+cast(@i as char(1))
+'='+cast(@i*@j as char(2))
+space(2)
,@j=@j+1
print @str
set @i=@i+1
end追问

从大到小排列的
9*9=81……9*1=1
.
.
.
1*1=1
像这样的。

用T-SQL语句怎样实现打印九九乘法表?
使用T－SQL语句打印九九乘法表的代码如下：--定义三个变量（行、列、输出字符串）通过横竖九行九列进行循环输出 DECLARE @a smallint,@b smallint,@str varchar(1000)set @a=1 WHILE @a<=9 BEGIN SET @b=1 SET @str=''WHILE @b<=@a BEGIN SELECT @str=@str+convert(varchar(1),@...

用pl\/sql 输出九九乘法表
第一、在Oracle9i下的脚本：SELECT to_char(flag)||'=1*'||to_char(flag) "1" ,CASE WHEN flag>1 THEN to_char(flag*2)||'=2*'||to_char(flag) ELSE '' END "2",CASE WHEN flag>2 THEN to_char(flag*3)||'=3*'||to_char(flag) ELSE '' END "3",CASE WHEN flag>3 T...

想深入学习C#语言,有没有达人知道C#的好的资料呢?
47. 编写一个程序,对输入的4个整数,求出其中最大值和最小值。48. 分别用for,while,do…while语句编写程序,实现求前n个自然数之和。49. 编程输出九九乘法表。50. 定义一个行数和列数相等的二维数组,并执行初始化,然后计算该数级两条对角线上的元素值之和。51. 建立一个一维数组,使用该数组列出所学习的课...

用T-SQL语句怎样实现打印九九乘法表?
使用T－SQL语句打印九九乘法表的代码如下：--定义三个变量（行、列、输出字符串）通过横竖九行九列进行循环输出 DECLARE @a smallint,@b smallint,@str varchar(1000)set @a=1 WHILE @a<=9 BEGIN SET @b=1 SET @str=''WHILE @b<=@a BEGIN SELECT @str=@str+convert(varchar(1),@...