[thelist] SQL Server auto-increment

[rudy]

> Auto-incrementing numbers.
> Does SQL Server have something like this?

hi sarah

sure does -- they're called identity fields

unlike an oracle sequence, where you can pull the next number and use it on
any table, a sql/server identity field is unique to its table, so in that
sense very much like the ms access autonumber

you can have an initial seed value and an increment (which default to 1,1),
and i'm pretty sure (would need to look this up, or wait a few secs for
scott or somebody else to jump in) they can also be random


rudy.ca