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.
Thanks in advance.