Hi,
Identity column does not guarentee a sequence. It just guarentees some UNIQUE value will be added to the row when it is inserted automatically.
In a relational database there is no concept of the rows ordered on Disk. Order can only be applied when they are selected out and for that you can use the CSUM or RANK function based upon fileds in the row ( like a timestamp embeded in the row by your application )
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.