Differences
This shows you the differences between two versions of the page.
identity_column [2018/10/15 12:52] |
identity_column [2021/04/05 11:23] (current) |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Identity Column ====== | ||
+ | Identity columns are nice way to let the system generate unique ids for each inserted row in a table. | ||
+ | |||
+ | By default the system doesn' | ||
+ | |||
+ | See [[https:// | ||
+ | |||
+ | ===== OVERRIDING USER VALUE ===== | ||
+ | If you want to the use the system generated values you can specify this on the SQL statement with '' | ||
+ | |||
+ | INSERT INTO ORDERS OVERRIDING USER VALUE | ||
+ | (SELECT * FROM TODAYS_ORDER) | ||
+ | |||
+ | |||
+ | ===== OVERRIDING SYSTEM VALUE ===== | ||
+ | If you want to the use the user provided values you can specify this on the SQL statement with '' | ||
+ | |||
+ | INSERT INTO ORDERS OVERRIDING SYSTEM VALUE | ||
+ | (SELECT * FROM TODAYS_ORDER) | ||
+ | |||
+ | {{tag> |