Answers for "query to insert data from one database to another"

SQL
-1

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)
Posted by: Guest on March-17-2020

Code answers related to "query to insert data from one database to another"

Code answers related to "SQL"

Browse Popular Code Answers by Language