Answers for "how to insert data from one database table to another database table in sql server"

SQL
4

migrate sql table another database

INSERT INTO dbo.YourTableNameHere
   SELECT *
   FROM [SourceServer].[SourceDatabase].dbo.YourTableNameHere
Posted by: Guest on March-10-2020
-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 "how to insert data from one database table to another database table in sql server"

Code answers related to "SQL"

Browse Popular Code Answers by Language