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 are translations and its use? : sql server analysis services, ssas
What are the rules to use the rowguidcol property to define a globally unique identifier column?
What are the types of database recovery models?
What is the difference between online clustering and Offline clustering?
Can You Use Data Mining Models In Ssrs?
What is meant by referential integrity?
What is a user-defined function in the sql server and what is its advantage?
What is the use of commit?
What is the difference between for auto and for nested?
How to create a view using data from another view?
How to enter comments in transact-sql statements?
Does any body please help me what question's have asked for SSRS in the interview?
Can you import Microsoft Excel data to SSRS?
what is the primary use of the model database? : Sql server administration
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration