/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 votes323 views3 answers
Mysqldump: couldn
SQL
0 vote317 views1 answer
Select other columns with distinct
SQL
3 votes353 views2 answers
Postgres alter table owner
SQL
0 vote298 views2 answers
Influxdb delete measurement based on date
SQL
13 votes336 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
7 votes379 views1 answer
Oracle pagination query rownum
SQL
0 vote343 views1 answer
To_date sql
SQL
0 vote317 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote332 views1 answer
Uncaught Error: Call to undefined function DatabaseOld\mysqli_connect()
SQL
1 vote365 views1 answer
Oracle insert multiple rows into same table
SQL