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
What is the difference between cube operator and rollup operator? : SQL Server Architecture
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
How to get the query of a table in sql server?
What is meant by referential integrity?
What are different types of replication in sql server?
What is the difference between a stored procedure and a user defined function?
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Is the log file is a part of file group?
What is isnull() operator?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What is the boxing and unboxing concept in .net?
what is the difference between count(*) and count(1) ?
What are triggers in ms sql server?
How do I clean up sql server transaction log?
Explain about system stored procedure?