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
When should you use an instead of trigger?
Describe different Processing Modes offered by SSRS?
Where is my database stored on the hard disk in ms sql server?
How to rename databases in ms sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
What is difference between materialized view and view?
Can we shrink data file in sql server?
Why Master database is required?
What is DCL?
How to use copy and concatenate commands in SQL?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?
What is a cursor, index in sql?
What is the difference between a stored procedure and a user defined function?
What is the full form of ddl?
How do I clean up sql server transaction log?