i don't know what are that BCP and BULK INSERT?
plz what do u mean?
the number of rows is more than 4,000,000 records
the data type char(8)
in table one the column primekey is primarykey
i'm using sqlserver 2005
this statment take 1:30 min to execute
****insert into temotable (select key from table1)
if i used a select statment...
Separate names with a comma.