[thelist] SQL Server auto-increment

[sarah]

I've been using Oracle for basically everything, but
we're switching to SQL Server because Oracle is pricey
and an overkill. I've been doing some research on SQL
Server to seek out problems with the transition and I
found one: Auto-incrementing numbers. Does SQL Server
have something like this? In Oracle I would just make
a sequence and have each new entry bump up one with
nextval. Even Access has that nice autonumber feature,
but I can't find something similar in SQL Server.
Anyone know of something, or a nice easy way to do
this?

Thanks a lot,
Sarah


__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - Buy the things you want at great prices. 
http://auctions.yahoo.com/