help me to select ROW_NUMBER in sql server 2000

Question

Post reply

help me to select ROW_NUMBER in sql server 2000

Asma Qureshi

SSC Enthusiast

Points: 104
More actions
October 15, 2008 at 1:44 am

#70832

help me to select ROW_NUMBER in sql server 2000
November 29, 2016 at 4:29 am

This was removed by the editor as SPAM
April 4, 2017 at 3:38 pm

This was removed by the editor as SPAM

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

ChiragNS One Orange Chip Points: 26137 More actions · Answer 1

ChiragNS

One Orange Chip

Points: 26137

October 15, 2008 at 2:13 am

#885067

there is no row_number () in sql 2000.

"Keep Trying"

Madhivanan-208264 SSCertifiable Points: 7516 More actions · Answer 2

Miss Qureshi (10/15/2008)
help me to select ROW_NUMBER in sql server 2000

Why do you want to have row_number?

Do you want to simply generate serial no for the recordset?

If so, do this numbering in the front end application if you use

Madhivanan

Failing to plan is Planning to fail

tbeadle SSCommitted Points: 1635 More actions · Answer 3

Hello,

Another way to have a row number is to use the alter table command and add a rowId int identity field to the table ( unless it already has an identity field ).

When you add the rowId column, it will create the column and populate it with a row number.

like :

alter table yourTableName

add rowId int identity

Regards,

Terry

Jeff Moden SSC Guru Points: 1004432 More actions · Answer 4

I disagree with the idea of NOT using an IDENTITY for such a purpose if it's on a Temp Table.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

Stephan Redmon Valued Member Points: 50 More actions · Answer 5

i usually just place what is needed into a temp table as below:

select

RowNumber = identity(int,1,1)

,Column_1

,Column_2

into #im_temp0

from <tableName>