Numbering rows : LUSENET : SQL Server Database Administration : One Thread

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



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,


-- Anonymous, July 13, 1999

Moderation questions? read the FAQ