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 to select all columns of all rows from a table with a select statement in ms sql server?
What happens when transaction log is full?
How can you transfer data from a text file to a database table? Or how can you export data from a table to a comma delimited (csv) file? Or how can you import data from ms access to a table in a database? Or how can you export data from a table to an excel file?
what is the primary use of the model database? : Sql server administration
What are recommended options to be used while using db mirroring? : sql server database administration
Explain where clause?
How many types of local tables are there in sql server?
What is the difference between executequery () and executeupdate ()?
What is auditing in sql server?
How to identify current user in ssrs report?
write an SQL query to list the employees who joined in the month of January?
What are pages and extents? : SQL Server Architecture
What is dbcc updateusage?
How to create indexed view?
What function does a database engine serve in the sql server?