| 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 |
|---|
Category | Misc SQL satements |
|---|
|
Description
This can be used when you are to do a larger change in a Produciton 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 |
...
...
