/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

3 votes164 views3 answers
Update join
SQL
0 vote171 views1 answer
Populate db from command line postgres
SQL
0 vote193 views2 answers
Pl sql auto increment
SQL
5 votes185 views1 answer
Sql integer to serial
SQL
1 vote172 views1 answer
Cannot load driver class: com.mysql.cj.jdbc.Driver
SQL
0 vote180 views1 answer
Custom row number
SQL
5 votes175 views2 answers
Oracle find all tables with column name
SQL
1 vote168 views1 answer
Size of all tables in a schema oracle
SQL
1 vote180 views1 answer
Wherein mysql
SQL
1 vote171 views3 answers
Mysql disable foreign keys check
SQL