一个循环插入数据到数据库的存储过程

表结构 

存储过程：

create proc AddData
@number int,
@name nvarchar(50)
as

/*得到最大id，若为空，则id=1*/
Declare @id As int
Select @id = Max(id) From test_sort
IF @ID Is Not Null
Set @ID = @ID+1
Else
Set @ID = 1

/*存储id到temp，以便计算插入的总数据量*/
declare @temp as int
set @temp=@id

/*存储name到str*/
declare @str nvarchar(50)
set @str=@name

WHILE @id < @temp+@number
BEGIN
SET @name = @str+cast(@id as nvarchar(50))
insert into test_sort (id,name) values (@ID,@name)
Set @id =@id +1
END
go

exec AddData 10,abc
go

此实例提供了一些流程控制，仅供学习存储过程参考。