declare @ID intbeginset @ID=1while @ID<=100000begininsert into table(ID)values(@ID)set @ID=@ID+1endend