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
- 9217 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
Difference between 2NF &3NF ?
How to modify an existing stored procedure in ms sql server?
What is a trigger in sql server?
What is data source object?
What is database replication?
What is sql server programming?
Does union all remove duplicates?
State a few properties of relational databases?
What are the types of normalization?
How to check parameter value in stored procedure sql server?
What are the aggregate and scalar functions?
What is DCL?
What happens if you delete a table that is used by a view?
Explain datetimeoffset data type in sal server 2008?
What is ms sql server reporting services?
