From: RG on 19 Jul 2010 10:19 We seem to have hit an oddity. We have a stored procedure that gets the next sequence number. It is protected by a transaction so no two processes could update the table of ids at the same time. Every so often, we get duplicates. How could that happen? Is the value based on mantissa? If so, is there a way to expanded it? Keep in mind, I can't change the type from float. Any help is greatly appreciated. Thanks in advance
From: Jeroen Mostert on 19 Jul 2010 10:56 On 2010-07-19 16:19, RG wrote: > We seem to have hit an oddity. > Please don't multi-post. If you have to post to multiple newsgroups, post to all of them at once. Followup to microsoft.public.sqlserver.programming. -- J.
|
Pages: 1 Prev: path to attach db Next: UDF: select field by its string name |