|
|
Posted by newtophp2000 on 06/20/06 11:36
Erland Sommarskog wrote:
> That should not even work; you cannot update an IDENTITY column.
You are right, of course. That was an error on my part when copying
and pasting from the query window. It was a plain INT field.
> The point here is that since sets up a save point and rolls back, the
> table remains available, and other processes are not blocked. At the
> same time, you know that you will not get the same value twice,
> because the generation of the IDENITTY value is not rolled back.
I am running some tests to see how it works, but so far, things look
great!
Thanks a lot for the great tip!
Navigation:
[Reply to this message]
|