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
- 8842 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
how many layers of tcp/ip protocol combined of? : Sql server database administration
How to modify an existing stored procedure in ms sql server?
Explain “@@rowcount” and “@@error” in sql server?
How to install sql server 2005 express edition?
How to get @@error and @@rowcount at the same time?
What is the process of normalization?
Differentiate between SQL and ORACLE joins and write their syntax.
How do I find the port number for sql server?
how to take backup bcp out for a column in table in sql server?
What is the difference between update lock and exclusive lock?
can you instantiate a com object by using t-sql? : Sql server database administration
Why do we partition data?
Differentiate between a primary key and a unique key.
You want to implement the many-to-many relationship while designing tables. How would you do it?
What is difference between joins and subqueries?
