var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: identity columns
Can some one provide some guidelines on when to use identity columns, the advantages, pros and cons to consider...etc
When and how would it be useful to use indentity columns?
Also..if such a column is used, are there any pitfalls, if uniqueness is enformed on another set of columns in the same table by means of a unique index?
Thanks in advance.
the favour is that you don't need to care about primary key values; they are automatically incremented. If you had a table for the high watermarks you may run in (dead)lockings if the hit rate ist high
for the cons and pitfalls look at rob verschoor's site at http://www.sypron.nl/idgaps.html