This article is tagged with: Sql select data from one database and insert into a different database and mysql

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)

This article is tagged with: Sql select data from one database and insert into a different database and mysql