VL SP2 Identity Column

[jyoung]

Not really a question or an answer and I don't know when this showed up, I assume in SP2.

Capture.PNG (7.84 KiB) Viewed 12860 times

Capture2.PNG (4.19 KiB) Viewed 12860 times

No more System Variables for Identifiers!

This makes me happier than it probably should. Lol.

-Joe

[bark]

Hi Joe
You assume correctly. I found this in the SP2 readme

SP2_identity column.JPG (72.56 KiB) Viewed 12831 times

[atostaine]

Can the returned RRN not equal the actual RRN? I think it's possible to increment the next value outside of an insert.

ALTER TABLE ORDER
ALTER COLUMN ORDERNO
RESTART WITH 5

[Stewart Marshall]

No more System Variables for Identifiers!

This makes me happier than it probably should. Lol.

-Joe

Me too.

Oddly though, after 25+ years incrementing a number by one, I recently encountered the idea that all identifiers should probably be 10 digit Base64 randomised values, giving 1,152,921,504,606,846,976 possible values.

[atostaine]

I just submitted an incident. We are seeing the identity column check disappearing when checking out a file for update.

Art