| Name | Type | Description |
|---|---|---|
| UNCHANGED | Number | Unchanged state. |
| INSERTED | Number | A new row has been added. |
| UPDATED | Number | The row has been modified. |
| DELETED | Number | The row has been deleted. |
| INSERTDELETED | Number | A row has been added and deleted. |
| MODIFIED | Number | MODIFIED means changed state (INSERTED, UPDATED, DELETED). |
| ALL | Number | ALL means all states except INSERTDELETED. |
| type | Number |
|---|---|
|
Unchanged state.
|
| type | Number |
|---|---|
|
A new row has been added.
|
| type | Number |
|---|---|
|
The row has been modified.
|
| type | Number |
|---|---|
|
The row has been deleted.
|
| type | Number |
|---|---|
|
A row has been added and deleted.
|
| type | Number |
|---|---|
|
MODIFIED means changed state (INSERTED, UPDATED, DELETED).
|
| type | Number |
|---|---|
|
ALL means all states except INSERTDELETED.
|