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

what is spatial nonclustered index

943

Is mysql the same as sql server?

913

What is after dml trigger?

954

Is it safe to delete log files?

868

What are user-defined functions (udfs) in sql server?

935

What happens to a trigger with multiple affected rows?

865

Is it true, that there is no difference between a rule and a check constraint?

972

What do you understand by triggers?

859

where can you add custom error messages to sql server? : Sql server administration

1046

How to modify the underlying query of an existing view?

931

What are the differences in Clustering in SQL Server 2005 and 2008 or 2008 R2?

984

Explain what is cte (common table expression)?

1066

Explain the flow of creating a cube? : sql server analysis services, ssas

1003

What does it mean to be in union?

871

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

1131