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

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

一楼的，借来用用