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
What are the different types of sql server replication? : sql server replication
What is filtered index?
What are the types of database recovery models?
How to change the data type of an existing column with "alter table" statements in ms sql server?
Does view occupy space?
Do you know what is lock escalation?
what are the reporting service components in SSRS?
What is db stored procedure?
how to restart sql server in single user mode? How to start sql server in minimal configuration mode? : Sql server database administration
Why do we use sql limitations? Which constraints can we use while making a database in sql?
Why I can not enter 0.001 second in date and time literals in ms sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
What is a covered index?
What triggers long term care?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?