Interested to Buy Any Domain ? << Click Here >> for more details...
how to get the rowid/rownumbes of a table in sqlserver
- 7 Answers
- 19276 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / samar
hi i had tried same but i am getting error
Server: Msg 195, Level 15, State 10, Line 1
'row_number' is not a recognized function name
here querry is
select row_number() over(order by Income_Verification_id
) from Dim_Income_Verification
plz reply !!
| Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
What is the significance of null value and why should we avoid permitting null values?
What is the sql case statement used for?
What is snapshot report?
Can select statements be used on views in ms sql server?
Why it is recommended to avoid referencing a floating point column in the where clause?
What are the different types of locks in the database?
What languages bi uses to achieve the goal?
Why SQL Agent is used?
You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date
How to invoke a trigger on demand?
What are entities and relationships?
What stored by the msdb?
What is cube dimension? : sql server analysis services, ssas
What is catalog views?
Do you know the capabilities of cursors?
