方法一:直接输出 declare @i int,@j int,@s varchar(1000) set @j=1 while @j<=9 begin select @s='',@i=1 while @i<=@j begin set @s=@s+convert(varchar,@i)+'×'+convert(varchar,@j)+'='+convert(varchar,@i * @j)+' ' set @i=@i+1 end set @j=@j+1 print @s end 方法二:通过表格输出 select case when a < 1 then '' else '1×'+cast(a as varchar)+'='+cast(a*1 as varchar) end as [1], case when a < 2 then '' else '2×'+cast(a as varchar)+'='+cast(a*2 as varchar) end as [2], case when a < 3 then '' else '3×'+cast(a as varchar)+'='+cast(a*3 as varchar) end as [3], case when a < 4 then '' else '4×'+cast(a as varchar)+'='+cast(a*4 as varchar) end as [4], case when a < 5 then '' else '5×'+cast(a as varchar)+'='+cast(a*5 as varchar) end as [5], case when a < 6 then '' else '6×'+cast(a as varchar)+'='+cast(a*6 as varchar) end as [6], case when a < 7 then '' else '7×'+cast(a as varchar)+'='+cast(a*7 as varchar) end as [7], case when a < 8 then '' else '8×'+cast(a as varchar)+'='+cast(a*8 as varchar) end as [8], case when a < 9 then '' else '9×'+cast(a as varchar)+'='+cast(a*9 as varchar) end as [9] from (select 1 as a union all select 2 union all select 3 union all select 4 union all select 5 union all select 6 union all select 7 union all select 8 union all select 9) as t1