/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 vote309 views1 answer
Count number of entires by months sql
SQL
0 vote291 views1 answer
Mysql utc timestamp
SQL
5 votes282 views4 answers
Sql check
SQL
2 votes318 views1 answer
Sqlplus clear screen
SQL
2 votes289 views1 answer
Sql server conection string
SQL
0 vote241 views2 answers
Denormalization in sql
SQL
2 votes314 views1 answer
Mysql increment value by 1 in update
SQL
1 vote273 views1 answer
MySQL AND Operator
SQL
0 vote298 views1 answer
Mysql select field if condition
SQL
1 vote293 views1 answer
Sql select contem uma palavra
SQL