Sql server 编写99乘法表

2022-07-31 08:59:16

Sql 组织编写语句

declare @one int,@tow int,@str varchar(100),@num int
select @one=1
while(@one<=9)
begin
select @tow=1,@str=''
      while(@tow<=@one)
      begin
       set @num =@tow*@one   --求积
       set @str+=' '+convert(varchar,@tow)+'*'+convert(varchar,@one)+'='+convert(varchar,@num) --拼接字符串
       set @tow=@tow+1
      end
          print @str
set @one=@one+1
end