/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

5 votes287 views2 answers
Get columns number sql
SQL
10 votes294 views2 answers
Rtrim sql
SQL
1 vote291 views2 answers
Create table if not exist
SQL
8 votes340 views2 answers
Default sql server port
SQL
0 vote279 views1 answer
T-sql check if data exists
SQL
5 votes314 views4 answers
Traduction
SQL
1 vote290 views1 answer
Sql server: difference between hashtable and table declared using declare keyword
SQL
0 vote269 views1 answer
Changer un mot de passe mysql
SQL
3 votes264 views3 answers
Print in pl sql
SQL
0 vote299 views1 answer
Rename constraint postgresql
SQL