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
What do you understand by a view? What does the with check option clause for a view do?
Which are new data types introduced in sql server 2008?
What is subquery in sql?
What do you mean by recursive stored procedure?
What is the difference between mysql and mysqli?
How much does sql server 2016 cost?
how we use window authentication connection with sql server.?
what are the different types of SSRS reports?
what is bit datatype and what's the information that can be stored inside a bit column? : Sql server database administration
What is the security principal at the database level that represents your session?
How many non clustered indexes there can be on table ?
What is a Join and explain its types?
Define left outer join?
What are xml indexes?
Can we write ddl in trigger?