Differences
This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | Previous revision | ||
insert_into_table_with_generated_always [2018/12/12 09:28] |
insert_into_table_with_generated_always [2021/08/05 15:42] (current) mihael |
||
---|---|---|---|
Line 1: | Line 1: | ||
+ | ====== Insert Into Table With Generated Always ====== | ||
+ | From time to time you need to insert a row of data into a table which has an identity column or a column with the definition containing '' | ||
+ | |||
+ | Specifying a value for the field won't work as the system wants to generated the value leaving your with an SQL error behind. | ||
+ | |||
+ | But there are ways to add a row: | ||
+ | |||
+ | * Specifying the fields on the SQL statement excluding the identity column | ||
+ | * using '' | ||
+ | * using '' | ||
+ | * using '' | ||
+ | |||
+ | See [[https:// | ||
+ | |||
+ | {{tag> |