copy table from one database to another database

Naveej ,

Yes , BCP is right option for huge data records.

and if you want to use above Query then You can use second Query that I mentioned above with 'chunk based' operation.

Thanks