SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>) FROM <TableName>

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

Question Posted / payal nath

Answer Posted / payal nath

SELECT ROW_NUMBER() OVER(ORDER BY <FieldName>)
FROM <TableName>

Is This Answer Correct ?

27 Yes

5 No

Please Help Members By Posting Answers For Below Questions

How do I open a .db file?

1020

Why do we use trigger?

948

What are sql server functions?

960

List some case manipulation functions in sql?

1008

How will you monitor replication latency in transactional replication? : sql server replication

1122

What are the source of constraints?

895

List all types of constraints in sql server?

991

Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture

1042

Tell me about builtinadministrator?

980

Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?

1368

As per your opinion what are the five top responsibilities of a dba? : sql server database administration

1103

How to transfer a table from one schema to another?

981

how can you check the level of fragmentation on a table? : Sql server administration

951

What are clustered and non-clustered index?

991

what is a self join? Explain it with an example? : Sql server database administration

921