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
How do I open a .db file?
Why do we use trigger?
What are sql server functions?
List some case manipulation functions in sql?
How will you monitor replication latency in transactional replication? : sql server replication
What are the source of constraints?
List all types of constraints in sql server?
Do you know what is raid and what are different types of raid configurations? : SQL Server Architecture
Tell me about builtinadministrator?
Is it possible to import data directly from t-sql commands without using sql server integration services? If so, what are the commands?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
How to transfer a table from one schema to another?
how can you check the level of fragmentation on a table? : Sql server administration
What are clustered and non-clustered index?
what is a self join? Explain it with an example? : Sql server database administration