How to a Query to copy data from on table to another table.
- 6 Answers
- 8004 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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
What are different types of subquery?
How do I determine how many instances of sql server are installed on a computer?
What are the different types of lock modes in sql server 2000?
What are indexes in ms sql server?
Explain differences between web edition and business edition?
What is difference between sql and sql server?
Is the order of columns in the set clause important in ms sql server?
What is a derived table?
What is report server project?
what is a schema in sql server 2005? : Sql server database administration
Tell me what is a linked server?
What is the need for group functions in sql?
Why use sub query in sql server and list out types of sub queries?
What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?
What are the different subsets of sql?
