adding identity column to existing table

[habneh]

Hello everyone

Hope you have a great easter weekend

I have one que

I have a table say tbl1

col1 col2
a xx
a yy
b zz
c ff
c gg

I want to add an indentity column to this existing table
so that it will be like this after I will have added the identity column

col0 col1 col2
1 a xx
2 a yy
3 b zz
4 c ff
5 c gg

How can I do that

Thanks

 

[habneh]

Instead of adding an identity column, I would like to have it like this

when I select a recor from tbl1, I would like to add identity column on the record set. so when I so select * from tbl1

the recordset would be like this

col0 col1 col2
1 a xx
2 a yy
3 b zz
4 c ff
5 c gg

 

[ptheriault]

What version of SQL is this?

Check out this thread. It has options for both 2000 and 2005.

thread183-1306393

- Paul
- If at first you don't succeed, find out if the loser gets anything.

 

[habneh]

Thank you very much paul that was a great help

 

[ptheriault]

no problem.

- Paul
- If at first you don't succeed, find out if the loser gets anything.