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
what is isolation level at dead lock?
What is resource db in sql server?
What are binary string data types in ms sql server?
What is read committed?
Determine when an index is appropriate?
What are the differences between stored procedure and view in sql server?
What is difference between joins and subqueries?
What are policy management terms?
Can I work with several databases simultaneously? : sql server management studio
What are the different subsets of sql?
How do I shrink an ldf file?
What happens if strings are casted into wrong code pages in ms sql server?
What are the properties of the relational tables?
How to get all stored procedures in sql server?
Explain an incremental backup?