/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 vote104 views1 answer
Mysql undo delete
SQL
16 votes115 views3 answers
Jwt secret key generator laravel
SQL
4 votes64 views2 answers
Select todays data postgres query
SQL
6 votes110 views1 answer
What is where clause in sql
SQL
3 votes105 views1 answer
Sql print all names that start with a given letter
SQL
0 vote103 views1 answer
Illuminate\Database\QueryException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'updated_at' in 'field list'
SQL
2 votes106 views1 answer
Oracle find unusable indexes
SQL
6 votes113 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote116 views1 answer
Mysqli_real_connect(): (28000/1045): Access denied for user 'u0738423'@'www8.aname.net' (using password: YES)
SQL
2 votes113 views3 answers
Copy data from one table column to another table column in sql
SQL