Hi there is a question copy only schema without data from one table to an

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

Question Posted / rajdeep gupta

Answer Posted / rajdeep gupta

Hi there is a question copy only schema without data from
one table to another

INSERT INTO A1 select name,address from A2 WHERE 1 = 2

Is This Answer Correct ?

1 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How do I install only the client tools of sql server 2000?

1059

How many partitions a clustered index has by default in sql server 2012?

1082

Explain the steps to create and execute a user-defined function in the sql server?

958

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2063

What is 2nf example?

984

What is the difference between inner join and equi join?

983

Where is localdb stored?

931

what is the primary use of the model database? : Sql server administration

1037

Explain database normalization?

1211

What are wait types?

1098

Tell me what is the significance of null value and why should we avoid permitting null values?

973

Explain what you mean by 3 tier architecture.

1068

Tell me about the approaches which you used to counter the DI problems.

1338

Can you explain what is sql server english query?

992

Is null vs coalesce?

863