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
Explain the database you used in your final year project?
Which tcp/ip port does sql server run on? How can it be changed?
What is “asynchronous” communication in sql server service broker?
Explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What does it mean to normalize a database and why would you do it?
What are the differences between union, intersect, and minus operators?
Can I work with several databases simultaneously? : sql server management studio
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is sql or structured query language?
Where is my database stored on the hard disk in ms sql server?
Can we do dml on views?
How to generate create function script on an existing function?
What is the difference between SQL notification and SQL invalidation?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
How to get a list of columns in a view using the "sp_columns" stored procedure?