[thelist] SQL Server auto-increment

sarah disaster7 at yahoo.com
Fri Jan 19 18:08:31 CST 2001


When you insert a row, do you insert a special
function into that column, or do nothing with that
column and it will just automatically increment?

Sarah



--- Scott_Brady at themoneystore.com wrote:
> 
> 
> In Enterprise Manager, when you're designing the
> table, set your auto-increment
> field so that its "Identity" box is checked and set
> the "Identity Field" to be
> what ever number you want to start at (defaults to
> 1). And of course make sure
> that you don't allow null values.
> 
> Scott
> 
> 
> 
> 
> ---------------------------------------
> For unsubscribe and other options, including
> the Tip Harvester and archive of TheList go to:
> http://lists.evolt.org Workers of the Web, evolt ! 


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




More information about the thelist mailing list