I'm using the shortcut, via properties. When i only need to generate one identifier, i set "(Is) identity" to "Yes", but i can't seem to do it for two rows. Please Help.
views:
18answers:
3
+2
A:
Why do you need two identifiers for one record?
Identifiers in an association table should be foreign keys to the identity values in the related tables, not autogenerated themselves, although you may have a single additional autogenerated identity key in the association table as well.
RedFilter
2010-09-09 21:05:21
+3
A:
no possible with anything that is built in, you will have to roll your own with triggers but with that comes locking and concurrency....don't do it
SQLMenace
2010-09-09 21:05:28
He could do a calculated column that is the autoincrement `PK * -1` - but I question the motive.
RedFilter
2010-09-09 21:22:09