Group: Forum Members
Last Active: Thu 18 Jun 2015
Posts: 98,
Visits: 1,382
|
Is it possible to set the order number to increment from a number other that 1?
We would like our live system to begin at 10000.
|
Group: Administrators
Last Active: Sun 27 Sep 2015
Posts: 115,
Visits: 706
|
Yes, run the below script to start by 10000.
DBCC CHECKIDENT ('tblKartrisOrders', RESEED, 9999);
Tue 24 Jan 2012 by
Mohammad
|