



Sequence a Number Field Without an Identity Column
To begin, create a table with dummy records: Create table Table1 ( [Record Value] varchar(20), [Record Date] smalldatetime)goinsert into table1 values (‘Record 1′,’07/21/2003’)insert into table1 values (‘Record 2′,’07/22/2003’)insert into table1