/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 vote257 views1 answer
How to get previous year from sysdate in oracle
SQL
0 vote241 views1 answer
Sql list dates between two dates
SQL
1 vote213 views3 answers
Remove unique key from a table
SQL
0 vote228 views1 answer
Version and edition of SQL Server Database Engine
SQL
0 vote236 views2 answers
Getting customers with no orders sql
SQL
3 votes255 views1 answer
Flutter sqlite auto incrementing id primary key
SQL
2 votes240 views1 answer
Sql to char function with date
SQL
0 vote240 views1 answer
Oracle c# multiple update sql
SQL
2 votes227 views1 answer
Postgresql add entry to table
SQL
0 vote217 views1 answer
What are the aggregate function in sql
SQL