IDENTITY SELECT

Hi All
How Can I Select From Table With IDENTITY For Row Count
The Table Has No IDENTITY Column
Select Col1,IDENTITY As Col2 From My Table
Col1 Col2
A 1
B 2
C 3
D 4
.. ..
ThanksHere is an article I wrote about this that might help:
http://www.databasejournal.com/feat...cle.php/2244821
"Taha" wrote:

> Hi All
> How Can I Select From Table With IDENTITY For Row Count
> The Table Has No IDENTITY Column
> Select Col1,IDENTITY As Col2 From My Table
> Col1 Col2
> A 1
> B 2
> C 3
> D 4
> ... ..
> Thanks
>
>
>
>|||OK
Thank You Greg Larsen
"Greg Larsen" <GregLarsen@.discussions.microsoft.com> wrote in message
news:CE2DF0A4-859B-465F-A55F-B4630F8917A7@.microsoft.com...
> Here is an article I wrote about this that might help:
> http://www.databasejournal.com/feat...cle.php/2244821
>
> "Taha" wrote:
>|||I have an article too. Not to compete with Greg, in fact I'm sure they're
similar. Just posting for completeness.
http://www.aspfaq.com/2427
"Taha" <taha105@.hotmail.com> wrote in message
news:OeRTdCwlGHA.4772@.TK2MSFTNGP04.phx.gbl...
> Hi All
> How Can I Select From Table With IDENTITY For Row Count
> The Table Has No IDENTITY Column
> Select Col1,IDENTITY As Col2 From My Table
> Col1 Col2
> A 1
> B 2
> C 3
> D 4
> .. ..
> Thanks
>
>
>