How to a Query to copy data from on table to another table.
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 |
Post New Answer View All Answers
How you can change a cross join into an inner join?
Which sql server table is used to hold the stored procedure script?
Do you know what are acid properties?
What is the difference between index seek vs. Index scan?
Why we need to use secondry database file? though, we can do same work using primary database file also.
How to change parameter value inside the report?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are different types of replication in sql server?
Explain syntax for dropping triggers?
How can you stop stored procedures from recompiling?
What is the use of commit?
How to find related tables in sql server?
What are sub reports and how to create them?
What is faster join or union?
Is foreign key unique?