Re: sql insert (ignore auto generated ID)

[dlclark@xxxxxxxxxxxxxxxx]

"MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx> wrote on 12/12/2018 
03:15:12 PM:
> I wondered about that.
> Hopefully he's not uploading a bunch of daily batches.  You know the 
ones 
> where it starts over with a new identity column of 1 every day and when 
> you insert that into the upload it hurls because 1 is already in use 
> (assuming the identity column is also a primary key constraint).


        In that case, he should use OVERRIDING USER VALUE .


Sincerely,

Dave Clark