sqlserver存储过程实现九九乘法口诀表

程序员文章站 2022-06-06 15:54:02

...

//1.创建存储过程

go

create procedure g 

as
declare @i int,@j int,@str varchar(max)
set @i=1
while @i<=9
begin
	set @j=1
	set @str=''
	while @j<aaa@qq.com
		begin
			set @aaa@qq.com+convert(char(1),@j)+'*'+convert(char(1),@i)+'='+convert(char(2),@i*@j)+' '
			set @aaa@qq.com+1
		end
	print(@str)
	set @aaa@qq.com+1
end 
go

//执行存储过程

exec g

//运行结果