/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

9 votes131 views1 answer
Sql server get utc date
SQL
1 vote133 views1 answer
Mysql get latest duplicate rows
SQL
0 vote121 views1 answer
CREATE MULTIPLE FK
SQL
0 vote170 views1 answer
000webhost database values insert
SQL
0 vote112 views1 answer
Jooq finding lastest value in table
SQL
3 votes140 views5 answers
Import MySQLdb as Database ModuleNotFoundError: No module named 'MySQLdb'
SQL
1 vote173 views1 answer
Sql oracle update multiple rows
SQL
14 votes142 views3 answers
SQL trim
SQL
9 votes136 views3 answers
Oracle undo usage by session
SQL
10 votes140 views5 answers
Between keyword in sql
SQL