March 24, 2008 at 4:56 am
i need help in setting up a custom urn for a table in a new db - i though of using a control table and incrementing the number via a trigger - anyone have a easier or better idea - possibly identity i guess?
March 24, 2008 at 5:39 am
- If using a param-table to manage sequence numbers, locking will be a big disadvantage.
- with identity columns, that is not the case.
Just keep in mind to only use it as a surrogate key, so not determining anything else from it (first, last, ...) but a relation key.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data and code to get the best help
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply