/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 vote207 views1 answer
Mysql root localhost run
SQL
5 votes287 views4 answers
Sql check
SQL
1 vote188 views1 answer
Mariadb alter user host
SQL
0 vote189 views1 answer
Inspecting a column unique/distinct values in SQL
SQL
20 votes202 views4 answers
Reset auto increment in MySQL
SQL
0 vote231 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote199 views1 answer
Set engine to innodb
SQL
3 votes193 views1 answer
Null sql
SQL
0 vote188 views1 answer
Sqlite select split string
SQL
1 vote207 views3 answers
Postgresql connect to database
SQL