SQL statement implementation, SQL Server 2000 and access copy the oldtable structure of the old table, or structure and content to the new table newtable
Both of them have been tried. The following code can be used in both databases (SQL Server 2000 and access.
-- Copy the new table structure
Select * into newtable from oldtable where 1 = 2
-- Copy the table structure and content to the new table
Select * into newtable from oldtable
If you only need to combine some fields in the old table or previous table or the summarized content into a field, you can
-- Copy some fields in the table structure to the new table.
Select title, type, price, notes OK into newtable2 from titles where 1 = 2
-- Copy the table structure and content to the new table. You can select fields.
Select title, type, price, pub_id-price OK into newtable2 from titles
You can also copy the table structure (you can select some fields as the new table) and insert the content.
-- Copy some fields in the table structure to the new table.
Select title Y1, type Y2, price Y3 into yongfa365 from titles where 1 = 2
-- Add data to the new table
Insert into yongfa365 (Y1, Y2, Y3) Select title, type, price from titles
In fact, we can see from the above example that no matter whether it is copying the table structure, content, or summary results, we can all go to a new table. Why? I think of it now, I can
(Select * from
Table) as a table, then there is an answer to this question: Since you can regard the selected result as a table, the table can be saved and directly saved as a real table, for later use.
You can remove the yellow font above and run the same code.