/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

1 vote289 views1 answer
Oracle dbms scheduler repeat interval every 5 minutes
SQL
0 vote293 views1 answer
Mysql grant all on all databases
SQL
6 votes259 views3 answers
Mysql change auto_increment start value
SQL
1 vote252 views1 answer
Mysql show current queries
SQL
6 votes261 views2 answers
Stored procedure to delete data from table in mysql
SQL
0 vote335 views1 answer
Sqlite send a query to a Sqlite DB with Ruby
SQL
0 vote292 views2 answers
Mysql dump database tables only
SQL
0 vote265 views1 answer
Get id if is not equal in certain table
SQL
0 vote279 views1 answer
Lost connection to mysql
SQL
8 votes260 views5 answers
Alter table add column with default value
SQL