/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 vote157 views1 answer
Mysql grant grant option
SQL
0 vote154 views1 answer
How to use query in nosql
SQL
0 vote149 views1 answer
C# datetime to sql server datetime
SQL
0 vote187 views1 answer
Postgres get database encoding
SQL
0 vote170 views1 answer
Oracle concat datetime
SQL
0 vote179 views1 answer
Reset postgres table index to next max value
SQL
2 votes242 views1 answer
How to create sql database
SQL
0 vote159 views1 answer
Postgresql copy backup table
SQL
1 vote166 views1 answer
Pentaho + pasar de excel a sql
SQL
0 vote176 views1 answer
Sql_inner_join
SQL