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
- 8809 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 sub query and its properties?
how to trace the traffic hitting a sql server? : Sql server database administration
Explain about Normalization?
What is the log shipping?
Where views are stored in sql server?
How to create a large table with random data for index testing in ms sql server?
What is the beast way to write CTE in SQL Server ?
What is change tracking in sql server?
Can we delete data from a view?
what are user defined datatypes and when you should go for them? : Sql server database administration
What is microsoft sql server?
Explain multiserver query
How to create a user to access a database in ms sql server using "create user" statements?
Can you tell me about the concept of ER diagrams?
How to create nested stored procedure?
