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
- 8841 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
Where cross join is used?
What are the characteristics of modern DBMS?
What are “lock” hints?
How do I make a resultset scrollable?
What are the different types of collation sensitivity?
What are the different SQL Server Versions you have worked on?
What do mean by xml datatype?
How to end a stored procedure properly in ms sql server?
Can you tell me about the concept of ER diagrams?
What is compound operators?
What is difference between Datepart() and Datename() in SqlServer?
What do you mean by acid?
How would you go about developing a ssrs report?
What is the usage of the sign function?
Some queries related to SQL
