how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 18134 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / renu
Row_number() works on SQL 2005 and upper version, if u r
trying it on 2000 it will not work.
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
What is database isolation in sql server? : sql server database administration
What is primary key index?
What is a trigger what are the advantages of trigger?
What is normalization? Explain different forms of normalization?
Difference between Logical Page and Physical Page in SSRS.
What is scd (slowly changing dimension)? : sql server analysis services, ssas
Explain logical operators in sql server?
Mention the different types of triggers?
what are user defined datatypes? : Sql server database administration
How to create percentile function?
Can an automatic recovery be initiated by a user?
What is buffer cash and log cache in sql server?
How many types of stored procedures are there in sql server?
How to create view in stored procedure sql server?
