How to a Query to copy data from on table to another table.
Answer Posted / gali kondareddy
INSERT INTO TABLE_2 SELECT * FROM TABLE_1
OR
INSERT INTO TABLE_2 SELECT * FROM TABLE_1 WHERE 1=1
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain what are various ways to enhance the ssrs report?
What you can do to delete a table without the delete trigger firing?
What is difference between drop truncate and delete?
How to provide values to stored procedure parameters in ms sql server?
How you can get the list of largest tables in a database?
How would you use user_constraints table in DB?
what is the difference between Tabular and Matrix report?
What is the tcp/ip port on which sql server runs?
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?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
What is Extended user-defined?
What is difference between clustered index and non clustered index?
What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas
How can we solve concurrency problems?
What does it mean to manipulate data?