/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

2 votes183 views1 answer
Foreign key example in dbms
SQL
0 vote221 views1 answer
Sql pad left 0
SQL
0 vote217 views1 answer
Contact mysql column field
SQL
3 votes243 views3 answers
1396(hy00) mysql error
SQL
0 vote220 views2 answers
Imageview setimageresource null
SQL
1 vote194 views1 answer
Sql auto timestamp
SQL
0 vote218 views1 answer
Cannot insert duplicate key in object 'dbo.Instructor'. The duplicate key value is (2).
SQL
6 votes213 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote210 views1 answer
Minus equivalent in my sql
SQL
4 votes223 views3 answers
Is not null sql
SQL