如何显示
1*1=1
2*1=2 2*2=4
3*1=3 3*2=6 3*3=9
.
.
.
9
请高手执教
------解决方案--------------------
declare @sql varchar(8000)
set @sql = ' '
declare @i int
declare @j int
select @i=1,@j=1
while @i <=9
begin
while @j <[email protected]
select @[email protected]+rtrim(@i) + '* ' + rtrim(@j) + '= ' + rtrim(@[email protected])+ ' ',@[email protected]+1
print @sql+char(13)
select @sql= ' ',@j=1,@[email protected]+1
end