Stuart McLachlan
stuart at lexacorp.com.pg
Fri Feb 25 22:23:36 CST 2011
I forgot to mention, it also means that you can create records with a "0" or negative values in your "autoincrement" field any time you like if you need to create special cases. That can be useful at times. -- Stuart On 26 Feb 2011 at 14:03, Stuart McLachlan wrote: > Basically, yes but you have lots of flexibility. > > If you change the column's Identity Seed to be larger than the current > largest PK, it will start from that instead. (If it is smaller, it > will use the current largest PK as it's start point). > > You can also set the size of the Increment, so you can have your PKs > going up by 10 each time if you want :-) > > Just right click on the column, select Modify, click on Identity > Specification in the lower panel and it will expand to show the > various settings. > > -- > Stuart > > On 25 Feb 2011 at 22:24, jwcolby wrote: > > > Does it just figure out the last value and start from there? > > > > John W. Colby > > www.ColbyConsulting.com > > > > On 2/25/2011 10:15 PM, Stuart McLachlan wrote: > > > Hi John, > > > > > > Yes, unlike Acces, in SQL Server you can switch autoincrement on > > > and off regardless of whether or not there are existing records in > > > the table. > > > > > _______________________________________________ > > dba-SQLServer mailing list > > dba-SQLServer at databaseadvisors.com > > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > > http://www.databaseadvisors.com > > > > > > > > _______________________________________________ > dba-SQLServer mailing list > dba-SQLServer at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/dba-sqlserver > http://www.databaseadvisors.com > >