SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, * FROM emp asc

how to get the rowid/rownumbes of a table in sqlserver

Question Posted / vimal

Answer Posted / vimal

SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, *
FROM emp

asc or desc required

Is This Answer Correct ?

7 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Explain error handling in ssis?

981

What is the sql server agent?

1057

How to provide login information for a new odbc dsn?

1002

What is the partitioning method?

993

Explain intellisense for query editing

995

How to stop log file growing too big?

976

What are logical/boolean operations in ms sql server?

996

Explain the third normal form(3nf)?

912

Is the order of columns in the set clause important in ms sql server?

939

What should be the fill factor for indexes created on tables? : sql server database administration

1108

What is user-defined multi-statement table-valued function?

1021

What is sql or structured query language?

1106

What is SQL Azure?

105

What is sql server 2000 work load governor?

1005

How to get a list of all tables with "sys.tables" view in ms sql server?

1002