/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

7 votes137 views1 answer
Safe update mysql
SQL
11 votes159 views3 answers
Sql line numbers
SQL
0 vote142 views1 answer
How to check replication lag in mySQL
SQL
0 vote146 views2 answers
Connect to mysql server mac terminal
SQL
10 votes136 views1 answer
Oracle view dependencies
SQL
14 votes163 views3 answers
Inner join sql oracle
SQL
5 votes161 views1 answer
Oracle nls parameters
SQL
0 vote132 views1 answer
Check if table exists oracle
SQL
0 vote164 views1 answer
A network or instance-specific error sql server
SQL
0 vote154 views1 answer
Query to count the number of rows in a table in sqlalchemy
SQL