How can I insert 100 rows into a table that has only one identity column

[jasmine23]

I am trying to insert 100 rows in a single queries into the table.
my table is CREATE User (ID INT IDENTITY(1,1))

Thanks in advance.

[r035198x]

Where are the rows coming from?

[jasmine23]

I just wanna insert the rows. for example, I want the 100 ID rows using identity column..
how can i inserts multiple rows if i don't use repeating INSERT INTO User DEFAULT VALUES
i am testing Identity column..
Thanks.

[r035198x]

It really depends on where you want the data to come from but you can use an insert into ... select statement like

INSERT INTO YourTable  (col1, col12, ..., coln)
       SELECT val1, val2  FROM SomeSource;

[jasmine23]

Thanks. r035198x
I see. But my data is not from other source. The identity column can generate key values. what I want to know is how can i insert to get 100 rows generating.

insert into User Default Values
insert into User Default Values

when I repeat the query two times and retrieve again, the result shows
ID
1
2
Like that i want to get 100 rows without inserting again and again.
Thanks.

[r035198x]

Does your table only contain one column? you should let the database generate the ids so that you don't need to insert them and just insert the other values. That way you don't need to manually increment.

If you insist on manually setting it then you need something like

DECLARE @CN INT
WHILE (@CN<=100)
BEGIN
INSERT INTO yourTable (columnName) SELECT @CN
SET @CN = @CN + 1
END

[jasmine23]

Thanks r035198x :)
I got it with your help. I used like

DECLARE @CN INT=1
WHILE (@CN<=100)
BEGIN
INSERT INTO User DEFAULT VALUES // I need to use IDENTITY column that's why 
set @CN +=1
END

[r035198x]

Ok, cool. Well done!