how to get the rowid/rownumbes of a table in sqlserver
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
Do you know what are the ways available in sql server to execute sql statements?
How to modify the underlying query of an existing view?
How do I know if localdb is running?
What is the sql profiler?
What are scheduled tasks in sql server?
What are the properties and different types of sub-queries?
Can I save my report as html, excel or word? : sql server management studio
Describe and explain about SQL native client?
How many types of database relationship in sql server?
What is b tree index?
What is a recursive stored procedure in sql server?
What is the difference between a unique key and primary key?
Differentiate between a having clause and a where clause.
How to resolve the orphan use problem? : sql server security
Where the sql logs gets stored? : sql server database administration