/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 vote110 views1 answer
Mysql offset from bottom
SQL
0 vote141 views1 answer
Insufficient memory to excute the sql query
SQL
0 vote141 views1 answer
Alter table myisam to innodb
SQL
0 vote107 views1 answer
Connection error in mysql workbench
SQL
1 vote141 views3 answers
How to get date in sql
SQL
8 votes156 views1 answer
Declare table variable sql server
SQL
1 vote168 views2 answers
Oracle 18c xe ORA-65096
SQL
0 vote168 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
9 votes158 views4 answers
Last mysql
SQL
-1 vote136 views1 answer
Mysql case when multiple conditions
SQL