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
- 9057 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answer Posted / dhiraj kumar
we have to use INSERT INTO method.
with the use of this method we can easily transfer records
from one table to another table but both table should have
similar columns or you need to select same no of columns
and datatype as inserting table
example:table A1 having 2 columns emp_name,emp_address
and A2 having 4 column name,address,city,dept
INSERT INTO A1 select name,address from A2.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is the difference between local and global temporary tables?
What is the difference between update lock and exclusive lock?
Characterize join and name diverse sorts of joins?
Do you know what is fill factor and pad index?
Explain about local stored procedure?
What is filestream?
How will you decide the active and passive nodes?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
Can you use order by when defining a view?
What are sql dirty pages?
How can we delete Duplicate row in table?
What is sql server english query?
What is replication with database mirroring? : sql server database administration
How to rename databases in ms sql server?
When to use null data driven subscription?
