User Profile

jasmine23 · Mar 13 '13, 10:12 AM

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

Code:

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

jasmine23 · Mar 13 '13, 09:21 AM

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....

jasmine23 · Mar 13 '13, 08:59 AM

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.

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

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