I have a simple table:

CREATE TABLE [MyTable]
(
    [Id]                INT IDENTITY(1, 1)      NOT NULL,
    [Name]              NVARCHAR(128)           NOT NULL
)

I would like to seed the table with data so it looks like:

Id      |   Name
-----------------------
1       |   user000001
2       |   user000002  
3       |   user000003
    
999999  |   user999999

I know I can make a spreadsheet that contains this data and import it into the table, but I’m guessing there’s a way to script this?