Create table with 15,000,000 default rows
This is a discussion on Create table with 15,000,000 default rows within the SQL Server forums, part of the Microsoft SQL Server category; --> Hi I want to create a table with one column, which is a identity column. Let's say like this: ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-29-2008, 06:48 AM
| ||||
| ||||
 Create table with 15,000,000 default rows Hi I want to create a table with one column, which is a identity column. Let's say like this: CREATE TABLE DefaultTable(N int identity(0,1)) Then I want to fill this table with 15,000,000 records, so that I have a table with the numbers 0 to 14,999,999. How can I do this as fast as possible. A standard INSERT would take a long time. (It can be a temp table or a table variable. I just need a list with numbered 0 to 15,000,000) Thank you. Gidon      |
|
02-29-2008, 06:48 AM
| |||
| |||
| Re: Create table with 15,000,000 default rows |
Linear Mode
