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 do you make a trace?
Does sql server 2000 full-text search support clustering?
Explain what are the authentication modes in sql server?
What is difference between count (*) and count 1?
What is a dataset and what are the different types of datasets?
Please explain go command in sql server?
How to recover from sql injection? : sql server security
What is 2nf normalization?
Can primary key be null?
Suppose i have a table that contains 5 columns like col1,col2...colm5.I want to import only two column through BCP utility.How to do same through BCP in sybase.
Which trace flags are enabled in sql server?
What is database replication?
How to provide default values to function parameters?
Explain triggers?
Using the customer, and order table in northwind database, please write a query to produce xml?