-
Challenge Overview 1 min
-
Answer Key 3 min
Increment the ID Field in a Table by 1
Write logic that will increment the value of each subsequent table record ID by 1. Simple concept, tricky to execute.
In this challenge, create trigger logic that will increment the ID field of a table in a series. Each new table record should have a value that is 1 greater than the previous. For example, if the value of the last record in a table is 800, you should write logic that will make the next record created 801. This pattern should continue though n.