copy table from one database to another database

@Prashanth: Is this the best practice or can we use BCP fro better performance???

Thanks