Use Database Identity Fields for Primary Key?

Arnold

BLOMASKY wrote
my 0.02 cents worth is PLEASE stay with INTs not GUID! Many times doing maintenance, I will find 1 (or more) records that I have to update and it is MUCH easier to type "UPDATE Table set field = 123 where ID between 100001 and 100003"

Bruce

Bruce - what kind of maintenance are you talking about and why is it needed - is it the result of the ID_GEN strategy or just "normal" maintenance? Just curious. Thanks

BLOMASKY

I am either "fixing" stuff that I coded wrong in aware, or (most of the time) the customer needs some data changed (like, WHOOPS, I entered new orders and I forgot to update the selling price 1st. Can you please update the following orders....)

So its stuff like "Update OrderLines set tripNumber = 0 where ID between ......"

Bruce

« Previous Page