Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "how to copy the data in the old table with sql sentences". In the operation of actual cases, many people will encounter such a dilemma, so let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Here is how to create an oracle

CREATE TABLE HZFAQ_EXAMINE_REAUDIT_LOG as SELECT * FROM HZFAQ_REAUDIT_LOG

Here is how to create a sqlserver

The following is without data

Select * into HZFAQ_EXAMINE_REAUDIT_LOG from HZFAQ_REAUDIT_LOG where 1: 2

The following is with data

Select * into HZFAQ_EXAMINE_REAUDIT_LOG from HZFAQ_REAUDIT_LOG

Here are how many pieces of data are needed.

Select top 0 * into newtb from tb

This is the end of the content of "how to copy the data in the old table with sql statement". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.