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
Explain differentiate between a having clause and a where clause?
What are the different Topologies in which Replication can be configured?
Explain the use of containers in ssis and also their types?
What is default port number for sql server 2000?
What are trace files?
How to find a value in another dataset based on current dataset field (ssrs 2008 r2)?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
What is an identity?
What are system databases into sql server (2005/2008) : sql server database administration
How do I edit a procedure in sql server?
What is index in an assignment?
If you are given access to a SQL Server, how do you find if the SQL Instance is a named instance or a default instance?
Explain the properties of sub-query in sql server?
What is temporal table?
Mention the different authentication modes in sql server.