How to a Query to copy data from on table to another table.
- 6 Answers
- 7977 Views
- Cap Gemini, I also Faced
- E-Mail Answers
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 is a transaction? : Sql server database administration
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Describe how to use linked server?
is it important for a database administrator to understand the operating system and file access? : Sql server administration
How do I find the sql server instance name?
Define full outer join in sql server joins?
How do you start single user mode in clustered installations?
Explain where clause?
What is the language structure to add a record to a table?
How can I create a report based on a query? : sql server management studio
what are statistics, under what circumstances they go out of date, how do you update them? : Sql server database administration
what are acid properties? : Sql server database administration
What are sql server functions?
What are the different types of normalization?
Which are new data types introduced in sql server 2008?
