Insert Values from One Database Table to Another Database Table in SQL Server

Introduction

Recently, I was working on the database and there is the situation in which I have to insert the values from one database table to the another database table.

Well, if the table have 2 or 3 values then we can write the Insert Query to insert the values in the table but suppose if there are too many values, then? The same thing happened to me. I have two tables in the database named State and City. There are 25 records in State and 590 records in the City table.

I got the solution to do this.

Solution

The structure of the Query is as follows:

USE Target_Database
GO

INSERT INTO dbo.Target_Table(Column1, Column2, Column3)
   SELECT Column1, Column2, Column3
   FROM Source_Database.dbo.Source_Table

 I have Converted this to the following query:

I have to insert values in two different tables:

Use Country

INSERT INTO dbo.State(State_Name)
   SELECT State_Name
   FROM CollegeDb.dbo.State

INSERT INTO dbo.City(State_ID, City_Name)
   SELECT State_ID, City_Name
   FROM CollegeDb.dbo.City

 Output

 

That's it. Happy Coding!!