INSERT MILLION RECORD SQL SERVER

Question

I have a table Employee, issue i dont know how to insert 1 million reocrd ( name ) into table, can you help me

Answer 1

Depending on the origin of data, and whether the source of data was supported, you might get some help by using import/export data wizard

https://learn.microsoft.com/en-us/sql/integration-services/import-export-data/start-the-sql-server-import-and-export-wizard

Answer 2

It would be all the records if there are less than a million records

Answer 3

i wanna insert from another table

Answer 4

Try to follow the steps described in attached link, hope it helps you find a way ...

Answer 5

INSERT INTO Employee
(col1, col2, col3, ...)
SELECT col1, col2, col3, ...
FROM AnotherEmployee
LIMIT 1000000;

Answer 6

but that table dont enough 1000000 row