Increment Collumn

[ofsouto]

I want to show all registers from a table(CODE, DESCRIPTION) and show an additional collum with the row number(INCREMENT).

Select * from table_1

RESULT:
CODE DESCTIPTION INCREMENT
-------- ------------------------- -----------
03354718 FIRST_DESCRIPTION 1
54654654 SECOND_DESCRIPTION 2
62173620 THIRD_DESCRIPTION 3

How can I get it?
Thank you very much

 

[mrdenny]

You'll need to add a column to the table with the INT data type. Then set this column to be an identity column.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(Not quite so old any more.)