CODEWITHSUNDEEP
sqlsql-server
Hamood Shi1707
Hamood Shi1707

Reputation: 71

Copy Table Data To Another Table In The Same Database

I Have a table name: KTS & Another Table Name KTS1 ,and both of them in the same DATABASE name HR ,I want to move the data table from KTS to KTS1.

Upvotes: 2

Views: 1219

Answers (1)

Rahul
Rahul

Reputation: 77846

Think you are looking to copy data from one table to another. If yes, then you can use insert into .. select from construct like below (assuming both table structure is exactly same, else you will have to manually specify the column names)

insert into kts1
select * from kts;

Upvotes: 2

Related Questions