[thelist] SQL Server auto-increment

Scott_Brady at themoneystore.com Scott_Brady at themoneystore.com
Fri Jan 19 17:59:31 CST 2001


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







More information about the thelist mailing list