How to insert table value from one database to another database

See more:

SQL

i want to select one table value and insert it to another table which is at another database.
here i clarify my question.
One database is located at my computer and there is a table named "test".
Another database is at web.
Now i want to select all the table value from my local database "test" table and insert all the values into web database "test table" .

Hope i can clearly mention my problem.
please reply.

Thanks in advance.