Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Table of Contents
minLevel1
maxLevel1
typeflat
separatorpipe
Page Properties

Description Summary

This SQL statement will provide you a backup of a selected fields and table.

Keywords

Back-up

...

This can be used when you are to do a larger change in a Production database and you want to have a backup of the affected tables in case something goes wrong, or just for look-up purposes of previous values before an update or deletion.

...

SQL Statement

Code Block
Select * into BK_pay_Payroll_20220624
From pw001pay

...