用SQL Server脚本语言输出九九乘法口诀表

declare @i int, @j int, @iResult int, @sLine varchar(255);

set @i=1;
while @i<=9
begin
    set @j=1;
    set @sLine='';
    while @j<=@i
    begin
        set @iResult=@i*@j;
        set @sLine=@sLine+ cast(@j as char(1))+'x'+cast(@i as char(1))+'=' +cast(@iResult as char(2));
        if @j>1 set @sLine=@sLine+' ';

        set @j=@j+1;
    end;
    print rtrim(@sLine);
    set @i=@i+1;
end;

效果图：