Returning Record Numbers - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Development (2000)

Returning Record Numbers

Author

Topic

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-06-06 : 12:27:45

Danilo writes "I want to return the record number of a record set..

ie
SELECT recNumber, field1, field2, field3 FROM table1

so my record set will look like:

recNumbe field1 field2 field3 
------------------------------------
1        some   data   here
2        some   data   here
3        some   data   here
4        some   data   here
5        some   data   here
6        some   data   here
7        some   data   here

I need to do this in SQL not is asp or vb

Thanks
Danny"

graz
Chief SQLTeam Crack Dealer

4149 Posts

Posted - 2002-06-06 : 12:27:45

We have an article on this. Search for "row number" or something like that.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources