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
- 9058 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 changed between the previous version of sql server and the current version? : Sql server database administration
What are the advantages of sql stored procedure?
What is filter index?
How to create a store procedure with encryption?
What is the maximum rows in sql server table?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
How to create “dependant” parameter “make, model, year”
What is spid in sql server profiler?
If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?
Why use identity in sql server?
What is the difference between update lock and exclusive lock?
how would you improve etl (extract, transform, load) throughput?
What is the purpose of indexing?
Explain tablesample?
Can two tables share the same primary key?
