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
此实例提供了一些流程控制,仅供学习存储过程参考。