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
How do I view views in sql server?
What is log in sql server?
What is cursor in ms sql server?
What is the purpose of indexing?
What are the different types of backups avaialabe in sql server 2005?
Explain primary key?
What is difference statement and preparedstatement?
Explain what is meant by replication of database?
How to concatenate two strings in SQL Server.
What is application role in sql server database security? : sql server security
Define constraints and give an example of their use?
Name the different type of indexes in sql?
Can I run multiple instances of sql server 2000 at the same time on one computer?
How to update values in a table with update statements in ms sql server?
What are indexes in ms sql server?