- DECLARE @MyCounter INT
- SET @MyCounter = 0
- insert into Table_1 values(1,2)
- WHILE (@MyCounter < 99)
- BEGIN
- --WAITFOR DELAY '000:00:00'
- INSERT INTO Table_1
- (ID, [Name])
- SELECT TOP 1 ID + 1 AS ID, [Name] + 1 AS [Name]
- FROM Table_1
- ORDER BY ID DESC
- SET @MyCounter = @MyCounter + 1
- END