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

Answer Posted / payal nath

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

Is This Answer Correct ?    27 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is isolation level at dead lock?

1927


What is resource db in sql server?

757


What are binary string data types in ms sql server?

823


What is read committed?

768


Determine when an index is appropriate?

763


What are the differences between stored procedure and view in sql server?

845


What is difference between joins and subqueries?

744


What are policy management terms?

743


Can I work with several databases simultaneously? : sql server management studio

747


What are the different subsets of sql?

1189


How do I shrink an ldf file?

735


What happens if strings are casted into wrong code pages in ms sql server?

833


What are the properties of the relational tables?

637


How to get all stored procedures in sql server?

693


Explain an incremental backup?

754