Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ramdas
Posting Yak Master
181 Posts |
 Posted - 2002-11-12 : 14:50:32
|
| Hi folks,I am trying to genrate a row id for each row, is there a way to do it.For example:Select fname from customerID Fname1 david2 john3 smithetc....ByeRamdas NarayananSQL Server DBA |
|
|
smccreadie
Aged Yak Warrior
505 Posts |
Posted - 2002-11-12 : 15:00:32
|
| How about IDENTITY? There is no internal row numbering as there is in Oracle. |
 |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-11-13 : 12:37:10
|
| search here for SEQUENCE NUMBERING or RUNNING TOTAL(s) or even ORACLEThis topic has has come up a lot....i think there is an 'official SQLTeam.com article' on solutions to same. |
|
|
|
|
|
|
Row Id for each row