how to get the rowid/rownumbes of a table in sqlserver
Answer Posted / vimal
SELECT ROW_NUMBER() OVER(ORDER BY eName ASC) AS Rno, *
FROM emp
asc or desc required
Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
How to create a large table with random data for index testing in ms sql server?
what are triggers? : Sql server database administration
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
What is check constraint in sql server?
What do we have to check in database testing?
What is 2nf normalization form?
What is read committed?
‘Order by’ is not allowed in a view how can you sort information from a view?
You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?
what are the new features in SSRS?
Why is normalisation important?
What does nvl stand for?
Name and describe few console utilities for ssrs?
How to connect to SQL Azure Database by using sqlcmd?
What is the default value of an integer data type in sql server 2005?