/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 vote66 views1 answer
Java spring jdbc connect to postgresql
SQL
0 vote95 views4 answers
Forenkey code alchemy sql
SQL
0 vote111 views1 answer
Count number of entires by months sql
SQL
0 vote97 views1 answer
Check sql database table lock
SQL
5 votes116 views4 answers
Traduction
SQL
5 votes162 views1 answer
Oracle source query
SQL
0 vote106 views1 answer
Longtext sql
SQL
0 vote106 views3 answers
Between keyword sql
SQL
0 vote110 views1 answer
Porcentaje sql
SQL
1 vote98 views1 answer
Select statement to print longest name
SQL