SELICT * INTO A1 FROM A2

How to a Query to copy data from on table to another table.

Question Posted / abhik kumar basu

Answer Posted / abhik kumar basu

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can you pass expressions to stored procedure parameters?

710

List out different types of normalizations in sql server and explain each of them?

720

What are different types of constraints?

698

What is the meaning of lock escalation and why/how to stop this? : sql server database administration

790

Explain DBCC?

736

How do I create a partition table in sql server?

742

What are dml (data manipulation language) statements in ms sql server?

740

What are security principals used in sql server 2005?

668

Explain “row_number()” in sql server with an example?

727

Explain about SQLOS?

770

What is measure group, measure? : sql server analysis services, ssas

771

What is bit data type?

797

What are the types of joins in sql?

786

Write a query to find 5th highest amount paid from the customer table.

708

What is a system database and what is a user database?

775