/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

13 votes217 views3 answers
Insert mysql ifile nto database
SQL
0 vote205 views1 answer
Turnicate in mysql
SQL
0 vote204 views3 answers
Mysql delete if not in another table
SQL
0 vote279 views1 answer
Sqlite update where exists
SQL
0 vote199 views1 answer
MySQL INSERT IGNORE Statement
SQL
2 votes220 views1 answer
Install postgresql centos 5
SQL
0 vote268 views1 answer
Inner join distinct
SQL
0 vote233 views2 answers
Oracle ora-00054 how to unlock
SQL
0 vote239 views1 answer
Delete first row in sql
SQL
7 votes195 views6 answers
Nth highest salary in sql
SQL