How to a Query to copy data from on table to another table.
Answer Posted / rajeshbargode
we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table.we can not only use this
method in the same server but can aslo be done across the
server.for exmaple.if we have two table A1 and A2 then the
code is
INSERT INTO A2 select * from A2.
Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
What does it mean to normalize a database and why would you do it?
What are the different types of replication you can set up in sql server?
In one interview...interviewer ask me question pleas tell me sql server architecture.. can any body tell me the sql server architecture with digram
What is a derived table?
We need to perform what steps in the following order to work with a cursor?
How to defragment table indexes?
Do you know the isolation level that sql server support?
Can a cursor be updated? If yes, how you can protect which columns are updated?
What is buffer cash and log cache in sql server?
What is the recursive stored procedure in sql server?
Define outer join in sql server joins?
Explain relational data?
What does COMMIT command do?
What are the diifferences between the ms sql server vs mysql?
What is clustered index