Table of Contents |
---|
minLevel | 1 |
---|
maxLevel | 1 |
---|
type | flat |
---|
separator | pipe |
---|
|
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 |
...