I was wondering if aside from using an identity col, there is sql to insert "n" rows into table and number them 1 to "n" automatically.

-- Anonymous, July 13, 1999

Answers

Darell,

You can keep a separate table with the max current row, or you can do a subquery to get the max current row.

Hope this helps,

Eric

-- Anonymous, July 13, 1999