/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 vote119 views2 answers
Uncaught Error: Cannot use object of type mysqli_result as array
SQL
0 vote116 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
9 votes116 views2 answers
Oracle all tables in schema
SQL
0 vote105 views1 answer
Sql beginning of previous month
SQL
0 vote119 views1 answer
Sql query for select from specific columns in a table
SQL
1 vote124 views1 answer
Sql server get users
SQL
7 votes113 views6 answers
Group_concat mysql
SQL
3 votes120 views2 answers
Sqlite show table definition
SQL
0 vote121 views1 answer
Enable Rabbitmq management plugin
SQL
0 vote110 views1 answer
Hw to delete a procedure in pl sql
SQL