/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

0 vote238 views1 answer
Original Query
SQL
21 votes193 views3 answers
Search for column name in sql db when i don't know which table it is in
SQL
3 votes186 views3 answers
Remove all spaces from string sql
SQL
0 vote193 views1 answer
Display first three characters sql
SQL
1 vote243 views1 answer
Sql sort column by date
SQL
1 vote186 views1 answer
Base nosql
SQL
0 vote142 views1 answer
Plsql trigger insert update
SQL
1 vote201 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote183 views1 answer
Mysqldump ignore table
SQL
-1 vote172 views1 answer
How to format tables in sqlplus
SQL