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

What are the steps you can take to avoid “deadlocks”?

978

What are the advantages to use stored procedures?

1109

Suppose you want to implement the many-to-many relationships while designing tables. How would you do it?

1005

How to convert numeric values to integers in ms sql server?

1093

How do you send email on SQL Server?

1064

What is serializable?

1042

What are extended events in sql server?

955

Can we take the full database backup in log shipping?

955

Explain what is cte (common table expression)?

1131

What are the different types of columns types constraints in the sql server?

1080

How to connect php with different port numbers?

1085

How do I start sql server 2017?

940

What is default constraint?

995

How to turn off warning messages during php execution?

1044

What are the steps you must follow to hide sql server instances?

978