/SQL/Sql select data from one database and insert into a different database

Sql select data from one database and insert into a different database

USE TargetDatabase
GO

INSERT INTO dbo.TargetTable(field1, field2, field3)
   SELECT field1, field2, field3
     FROM SourceDatabase.dbo.SourceTable
     WHERE (some condition)

-1

Source: stackoverflow.com

Similar codes

1 vote122 views1 answer
Import mysql dump database command line linux
SQL
5 votes120 views1 answer
Oracle columns in all_tables
SQL
0 vote130 views1 answer
Running mysql from bash sc
SQL
3 votes122 views2 answers
Mysql config user password
SQL
0 vote145 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote130 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
12 votes130 views2 answers
Select into insert sql server
SQL
0 vote120 views1 answer
Truncate a table then insert data
SQL
2 votes124 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote119 views1 answer
When mysql server would not work in xampp
SQL