Automatically generating Guids in Sybase
Posted
by Daniel Dyson
on Stack Overflow
See other posts from Stack Overflow
or by Daniel Dyson
Published on 2010-04-15T13:38:41Z
Indexed on
2010/04/24
11:13 UTC
Read the original article
Hit count: 176
sybase
I have a table with 42 million records. 32 million have a null value and I would like to generate a new guid for each one. Should I do this in batches?
Also, going forward, I would like a new guid added to the field on the insert of a new record. What is the best way to do this?
The field is not the primary key, which is an auto-incrementing integer.
© Stack Overflow or respective owner