Interested to Buy Any Domain ? << Click Here >> for more details...
How to a Query to copy data from on table to another table.
- 6 Answers
- 8855 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 is implicit mode in sql server?
How to test subquery results with the exists operator?
Can I use sql azure as a backup with log shipping or database mirroring?
Can we take the full database backup in log shipping?
What is normalization? Describe its different types.
Can you explain about buffer cash and log cache in sql server?
How can we improve performance by using SQL Server profiler?
What are different types of table joins?
How to check if a table is being used in sql server?
What are the differences between triggers and stored procedures?
How to run sql server 2005 books online on your local system?
What is row_number function?
What is the use of keyword with encryption. Create a store procedure with encryption?
How can you list all the columns in a database?
What are the pre-defined functions in the sql server?
