How to a Query to copy data from on table to another table.
Answer Posted / mohamed ibrahim
To Copy the data from one table to another table
for ex . i have the table named as TempMaster that having
the fields ID ,Name .The having the following record
ID Name
1 Raja
2 Mohamed
I want the same record copy to TempMasterArcheived table
to copy this using the following code:
INSERT INTO TempMasterArcheived
EXECUTE
('SELECT * FROM TempMaster ')
ID Name
1 Raja
2 Mohamed
after the output of TempMasterArcheived is as follows
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is sql server difficult to learn?
What is indexed view?
Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication
How to create prepared statements using odbc_prepare()?
What is user defined stored procedures?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
How to use copy and concatenate commands in SQL?
What is sql collation?
How does a profiler work?
How to connect ms access to sql servers through odbc?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
Can you explain what are commit and rollback in sql?
What is difference between aggregate and analytic function?
How to use linked server?
Do you know the cursor optimization tips?