/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

2 votes195 views1 answer
Tsql copy table
SQL
0 vote129 views1 answer
Select from another database
SQL
0 vote126 views2 answers
Many to many flask-sqlalchemy
SQL
8 votes126 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote132 views1 answer
How to set all the min and sec data to zero in sql server
SQL
7 votes140 views2 answers
Sql server drop temp table if exists
SQL
0 vote131 views1 answer
Postgres copy command
SQL
2 votes164 views1 answer
Datefromparts mssql
SQL
1 vote131 views1 answer
Mysql random limit 1
SQL
4 votes140 views1 answer
Mysql biginteger size
SQL