/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 vote128 views1 answer
Oracle query to see what scema i am working in
SQL
36 votes127 views6 answers
Delete from where sql
SQL
0 vote134 views1 answer
Postgres sql alter table delete row
SQL
2 votes142 views2 answers
Postgres timestamp to datetime
SQL
0 vote125 views1 answer
Sql contains numeric characters
SQL
0 vote132 views1 answer
Restore backup mysql .gz
SQL
0 vote130 views1 answer
Sql select by content lenght
SQL
3 votes168 views2 answers
@sqlresultsetmapping
SQL
3 votes155 views3 answers
Illuminate database queryexception could not find driver (sql select * from
SQL
2 votes129 views1 answer
Could not find driver (SQL: select * from information_schema.tables where table_schema = francis_koopmart and table_name = migrations and table_type = 'BASE TABLE')
SQL