Copy / Insert Data from one table to another table in SQL Server

Please remove backup Twinning song

I have an inventory table and a locations table. When i inserter the location column into the inventory table it shows null in the columns beside the columns with inventory data then finally shows the locations data on the right side after all the inventory data says null. How can i get the data beside each other?

It's not working

this is not working , showing db2 does not exist but its exist

i hvae tried in sql(livesqloracle):
CREATE TABLE CUSTOMERS(ID INT PRIMARY KEY, NAME VARCHAR2(20), AGE INT);
INSERT INTO CUSTOMERS VALUES(1, 'JACK', 20);
INSERT INTO CUSTOMERS VALUES(2, 'ALICE', 30);
INSERT INTO CUSTOMERS VALUES(3, 'JACKY', 25);
SELECT *FROM CUSTOMERS;

SELECT * INTO CUST FROM CUSTOMERS;

Hello great job. but it comes the same command create new_table and insert data at the same time.?

good job bro

Nice, really nice. Your video just saved me.
I mistakenly updated a live live database and had to restore only a certain table and your video helped.
Please note that if the exact table exists in the database if should be deleted before restoring.

Will it copy even the index of the table??

Hello Sir ,

Please let me know the script for moving only updated data from one table to another in a different database.
So the thing is, I have already created the new DB and restore few tables there. Now I only want to move data that is updated in those tables today or every day.

Please Help!

Please make a video on ‘how to data migrate from one table to another Table by using store procedure in oracle.

Good one boss. But how can you copy from a table to another different table having different header configuration?