Program is 5 years with the development of the original concept, the database is SQL server2000, in October after a data update, there will be no new data to the database, the database of other statements: can perform, such as the query log database log is only 5 days, there is nothing valuable clues, preliminary judgment because the database table name changes, cause data cannot be inserted,

CodePudding user response:

Is a simple way to manually create the same view and the name of the table, and then add a trigger, through the trigger to transfer data to the revised list