当前位置:首页 » 编程语言 » sql99乘法表
扩展阅读
webinf下怎么引入js 2023-08-31 21:54:13
堡垒机怎么打开web 2023-08-31 21:54:11

sql99乘法表

发布时间: 2022-12-13 01:42:01

❶ T-sql语句打印九九乘法表

declare @d int,@kk varchar(500),@c int
select @d=1
select @c=1
select @kk=''
while @d<=9
begin
select @c=1
while @c<=@d
begin
select @kk=@kk+char(10)+convert(varchar(200),@c)+'*'+convert(varchar(200),@d)+'='+convert(varchar(200),@d*@c)
select @c=@c+1
end
select @kk=@kk+char(10)
select @d=@d+1
end
print @kk

❷ 用T-SQL语句怎样实现打印九九乘法表

使用T-SQL语句打印九九乘法表的代码如下:

--定义三个变量(行、列、输出字符串)通过横竖九行九列进行循环输出

DECLARE@asmallint,@bsmallint,@strvarchar(1000)

set@a=1

WHILE@a<=9

BEGIN

SET@b=1

SET@str=''

WHILE@b<=@a

BEGIN

SELECT@str=@str+convert(varchar(1),@b)+'*'+convert(varchar(1),@a)+'='+convert(char(2),@a*@b)+space(2)

SET@b=@b+1

END

PRINT@str

SET@a=@a+1

(2)sql99乘法表扩展阅读:

T-SQL语句

T-SQL 即 Transact-SQL,是 SQL 在 Microsoft SQL Server 上的增强版,它是用来让应用程序与 SQL Server 沟通的主要语言。T-SQL 提供标准 SQL 的 DDL 和 DML 功能,加上延伸的函数、系统预存程序以及程式设计结构(例如 IF 和 WHILE)让程式设计更有弹性。

❸ sql中pring输出后怎么才能不换行 想打印99乘法表

这个没办法不换行,不过可以通过另一种方式实现,你可以试试,就是声明一个varchar的变量,在输出每一行的时候在本行信息不完整时先将字符信息都存储在这个变量中,等达到本行输出条件时,再执行print命令输出这个变量中的内容,之后再清空用来存放下一行的数据

❹ 如何用sql语言实现九九乘法表 要下三角格式的。

DECLARE@TTint,@NNint,@SSvarchar(60)
SET@TT=9
PRINT'*123456789'
WHILE@TT>=1
BEGIN
SET@SS=STR(@TT,1)+SPACE((9-@TT)*4)
SET@NN=10-@TT
WHILE@NN<=9
BEGIN
SET@SS=@SS+STR(@TT*@NN,4)
SET@NN=@NN+1
END
PRINT@SS
SET@TT=@TT-1
END

❺ 用SQL语句打印九乘九法

SQL语句只是进入数据库,读取数据库,修改数据库。。
你要打印99乘法表,先得把乘法表做好,然后SQL读取出来。

❻ 用sql server 做九九乘法表,该怎样做

declare @i int
declare @j int
declare @str varchar(max)
set @i=1
set @str=''
while @i<=9
begin
set @j=1
while @j<=@i
begin
set @str=@str+cast(@j as varchar)+'*'+cast(@i as varchar)+'='+cast(@i*@j as varchar)+' '
set @j=@j+1
end
set @str=@str+char(10)+char(13)
set @i=@i+1
end
print @str

❼ 用pl/sql 输出九九乘法表

经过测试,可以直接使用

第一、在Oracle9i下的脚本

SELECTto_char(flag)||'=1*'||to_char(flag)"1",

CASEWHENflag>1THENto_char(flag*2)||'=2*'||to_char(flag)ELSE''END"2",

CASEWHENflag>2THENto_char(flag*3)||'=3*'||to_char(flag)ELSE''END"3",

CASEWHENflag>3THENto_char(flag*4)||'=4*'||to_char(flag)ELSE''END"4",

CASEWHENflag>4THENto_char(flag*5)||'=5*'||to_char(flag)ELSE''END"5",

CASEWHENflag>5THENto_char(flag*6)||'=6*'||to_char(flag)ELSE''END"6",

CASEWHENflag>6THENto_char(flag*7)||'=7*'||to_char(flag)ELSE''END"7",

CASEWHENflag>7THENto_char(flag*8)||'=8*'||to_char(flag)ELSE''END"8",

CASEWHENflag>8THENto_char(flag*9)||'=9*'||to_char(flag)ELSE''END"9"

FROM(

SELECT1flagFROMal

UNIONALL

SELECT2FROMal

UNIONALL

SELECT3FROMal

UNIONALL

SELECT4FROMal

UNIONALL

SELECT5FROMal

UNIONALL

SELECT6FROMal

UNIONALL

SELECT7FROMal

UNIONALL

SELECT8FROMal

UNIONALL

SELECT9FROMal)a

二、在sqlserver下脚本:

selectconvert(varchar(10),flag)+'=1*'+convert(varchar(10),flag)[1],

casewhenflag>1thenconvert(varchar(10),flag*2)+'=2*'+convert(varchar(10),flag)else''end[2],

casewhenflag>2thenconvert(varchar(10),flag*3)+'=3*'+convert(varchar(10),flag)else''end[3],

casewhenflag>3thenconvert(varchar(10),flag*4)+'=4*'+convert(varchar(10),flag)else''end[4],

casewhenflag>4thenconvert(varchar(10),flag*5)+'=5*'+convert(varchar(10),flag)else''end[5],

casewhenflag>5thenconvert(varchar(10),flag*6)+'=6*'+convert(varchar(10),flag)else''end[6],

casewhenflag>6thenconvert(varchar(10),flag*7)+'=7*'+convert(varchar(10),flag)else''end[7],

casewhenflag>7thenconvert(varchar(10),flag*8)+'=8*'+convert(varchar(10),flag)else''end[8],

casewhenflag>8thenconvert(varchar(10),flag*9)+'=9*'+convert(varchar(10),flag)else''end[9]

from

(select1flag

unionall

select2

unionall

select3

unionall

select4

unionall

select5

unionall

select6

unionall

select7

unionall

select8

unionall

select9)a

❽ 用sql输出倒置的99乘法表

declare@resultvarchar(max)='',@tempchar(10)
declare@iasint=9,@jasint=1;
while(@i>=1)
begin
while(@j<=@i)
begin
set@temp=STR(@i,1)+'*'+STR(@j,1)+'='+STR(@i*@j,2);
set@result=@result+@temp;
set@j=@j+1;
end
set@result=@result+CHAR(10)
set@i=@i-1
set@j=1
end
print@result

这个是SQL SERVER的写法,如果是其他数据库,大体上应该也都差不多,试试看吧。

❾ 数据库编程做九九乘法表

语言种类太多了,所有语言都可以写出乘法表

SQL写99乘法表
1:

select r1 || '*' || 1 || '=' || r1 * 1 A,
decode(r2, '', '', r2 || '*' || 2 || '=' || r2 * 2) b,
decode(r3, '', '', r3 || '*' || 3 || '=' || r3 * 3) C,
decode(r4, '', '', r4 || '*' || 4 || '=' || r4 * 4) D,
decode(r5, '', '', r5 || '*' || 5 || '=' || r5 * 5) E,
decode(r6, '', '', r6 || '*' || 6 || '=' || r6 * 6) F,
decode(r7, '', '', r7 || '*' || 7 || '=' || r7 * 7) G,
decode(r8, '', '', r8 || '*' || 8 || '=' || r8 * 8) H,
decode(r9, '', '', r9 || '*' || 9 || '=' || r9 * 9) I
from (select level r1,
lag(level+1, 1) over(order by level) r2,
lag(level+2, 2) over(order by level) r3,
lag(level+3, 3) over(order by level) r4,
lag(level+4, 4) over(order by level) r5,
lag(level+5, 5) over(order by level) r6,
lag(level+6, 6) over(order by level) r7,
lag(level+7, 7) over(order by level) r8,
lag(level+8, 8) over(order by level) r9
from al
connect by level < 10)

2:

select rn, ltrim(max(sys_connect_by_path(proct, ',')), ',') proct
from
(
select rn, proct, min(proct) over(partition by rn) proct_min
,(row_number() over(order by rn, proct)) + (dense_rank() over(order by rn)) numId
from
(
select b.rn, a.rn || '*' || b.rn || '=' || a.rn * b.rn proct
from (select rownum rn from all_objects where rownum <= 9) a,
(select rownum rn from all_objects where rownum <= 9) b
where a.rn <= b.rn
order by b.rn, proct
)
)
start with proct = proct_min
connect by numId - 1 = prior numId
group by rn

❿ sql语句实现四种九九乘法表

下面用while

if
条件写的SQL语句的四种九九乘法表
sql语句实现--x
左下角九九乘法表
DECLARE
@I
INT
,@J
INT,@S
VARCHAR()
SET
@I=
WHILE
@I<
BEGIN
SET
@J=
SET
@S=''
WHILE
@J<=@I
BEGIN
SET
@S=@S+CAST(@J
AS
CHAR())+'*'+CAST(@I
AS
CHAR())+'='+CAST((@I*@J)AS
CHAR())
SET
@J=@J+
END
PRINT
@S
SET
@I=@I+
END
结果:
sql语句实现--X
右下角九九乘法表
DECLARE
@I
INT
,@J
INT,@S
VARCHAR()
SET
@I=
WHILE
@I<
BEGIN
SET
@J=
SET
@S=''
WHILE
@J>
BEGIN
IF
@J>@I
BEGIN
SET
@S=@S+'
'
--七个空格
END
ELSE
BEGIN
SET
@S=@S+CAST(@I
AS
CHAR())+'*'+CAST(@J
AS
CHAR())+'='+CAST((@I*@J)AS
CHAR())
END
SET
@J=@J-
END
PRINT
@S
SET
@I=@I+
END
结果:
sql语句实现--9X9右上角
DECLARE
@I
INT
,@J
INT,@S
VARCHAR(100)
SET
@I=1
WHILE
@I<10
BEGIN
SET
@J=1
SET
@S=''
WHILE
@J<10
BEGIN
IF
@J<@I
BEGIN
SET
@S=@S+'
'--7
END
ELSE
BEGIN
SET
@S=@S+CAST(@I
AS
CHAR(1))+'*'+CAST(@J
AS
CHAR(1))+'='+CAST((@I*@J)AS
CHAR(3))
END
SET
@J=@J+1
END
PRINT
@S
SET
@I=@I+1
END
结果:
sql语句实现--9X9左上角
DECLARE
@I
INT
,@J
INT,@S
VARCHAR(100)
SET
@I=1
WHILE
@I<10
BEGIN
SET
@J=@I
SET
@S=''
WHILE
@J<10
BEGIN
SET
@S=@S+CAST(@I
AS
CHAR(1))+'*'+CAST(@J
AS
CHAR(1))+'='+CAST((@I*@J)AS
CHAR(3))
SET
@J=@J+1
END
PRINT
@S
SET
@I=@I+1
END
结果:
以上内容就是通过四种方式写的九九乘法表,希望大家喜欢。