Question

T-SQL语句打印九九乘法表

显示如下：
1*1=1
2*1=2
2*2=4
3*1=3
3*2=6
3*3=9
......

Answer 1

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

Answer 2

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

Answer 3

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

Answer 4

一楼的，借来用用