hi

I have two tables of same type signature
I need to write an sql query that can insert(add) all data from one
table to another table. In the query i don't want to write column
names because one table is exactly similar to another table. just we
need to copy data of one table to another.
any help

thanks

dotnet

__________________
dotnet

you can use INSERT Command for eg.,
INSERT INTO Employees
SELECT Trainees.*
FROM Trainees
WHERE HireDate < Now() - 30;


Selects all trainees who were hired more than 30 days ago and adds their records to the Employees table.


Gokulan Ethiraj