Posted by --CELKO-- on 09/18/05 17:57
>> But if i check the IDENT_CURRENT from a newly created table the result should be NULL, or not? <<
What would a NULL value mean? Why not zero? Remember IDENTITY is
proprietary and non-relational, so it can do anything it wants.
Think about how it would work if you had a 1950's sequential tape file
system. The counter starts at one and is incremented after the
insertion instead of before. It is the position of the read/write head
of the maganeitc tape drive.
Navigation:
[Reply to this message]
|