Loop Insert

DECLARE @counter int;
SET @counter = 0;

while(@counter<10)
BEGIN;
    SET @counter = @counter + 1;

    INSERT INTO myTable
    (myColumn)
    VALUES
    ('number' + CAST(@counter as varchar))
END;