这里只是设置了默认值,你可以在代入参数时指定。
@StartID int = 1000,
@EndID int = 2000
CREATE PROCEDURE InsertDB
@StartID int = 1000,
@EndID int = 2000
AS
While StartID <= @EndID
Begin
Insert Into Table Values (Select .....)--这里写你的插入SQL语句
Set @StartID = @StartID +1--这里计数器加1
End
CREATE PROCEDURE InsertDB(@StartID int ,@EndID int )
AS
declare @CurrentID int
set @CurrentID = @StartID
While @CurrentID <= @EndID
Begin
Insert Into Table Values (Select .....)
End