Hi guys,

I try to insert 1 million rows into an empty table, test table.
but it takes too long to insert 1 million row.
how can I make it faster?


DECLARE @number INT
SET @number = 0
WHILE  @number <1000000
BEGIN
   set @number = @number+1
   INSERT INTO table1 values (@number, '1111111111')
   IF @number = 1000000
      BREAK
   ELSE
      CONTINUE
END

create table #t(i int identity, l int)
insert into #t select 1
from dbo.syscolumns

select t1.i*1000 + t2.i i
into #tt
from #t t1, #t t2
where t1.i < 1001 and t2.i < 1001

select count(*) from #tt

-----------
1000000

(1 row(s) affected)

a really bad ordering problem
Calculated fields with Days/Dates
Automating database changes
Dangers of update statement
One Small Question regarding Date Format