How to a Query to copy data from on table to another table.
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 are the advantages of user-defined functions over stored procedures in sql server?
Explain linked server in sql?
What are data resources?
What does it mean to be in union?
How is sql used in sql server?
Explain system scalar functions?
How to how to convert numeric expression data types using the convert() function??
How to delete an existing database user?
What is dknf in normalization form?
What is the difference between a function and a trigger?
Give an example of why you would want to denormalize a database
how many triggers you can have on a table? : Sql server database administration
1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?
What is the difference between system objects and user objects?
Write a program to fetch first 10 records from a file?