/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

16 votes282 views3 answers
Jwt secret key generator laravel
SQL
0 vote275 views1 answer
USING THE NOT CONDITION IN SQL
SQL
0 vote274 views1 answer
Mysql query problems and solutions
SQL
0 vote281 views1 answer
Mysql timediff
SQL
-1 vote265 views1 answer
How to open blade file from blade in laravel
SQL
13 votes250 views11 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysql.sock' (2) Ask
SQL
0 vote275 views1 answer
Docker open terminal mysql server
SQL
1 vote265 views2 answers
Update with inner join sql server
SQL
1 vote287 views1 answer
Setval pgsql
SQL
0 vote260 views1 answer
Dasebase_url-postgres for windows
SQL