Forum Discussion
Using a Sequence
Consider this table: CREATE TABLE [Events](
[EventID] [int] NULL,
<< Other columns >> and this Sequence: CREATE SEQUENCE [NewEventID]
AS [int]
START WITH 1
INCREMENT BY 1
MINVALUE ...
Maybe I'm misunderstanding your need but why would you not use an Identity field?
Because I load 300+ entries into the Events table every time it gets loaded, then those entries are deleted when the app terminates. I don't need an EventID for those entries so using an identity column makes no sense.
