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
What are the different type of replication in sql server?
Explain mixed authentication mode of sql server?
Explain the xml support sql server extends?
What is the dbcc command and why is it used?
How many databases can we create in a single server?
What are the system database in sql server 2005?
What are constraints?
What are the restrictions that views have to follow? : SQL Server Architecture
What are the key configuration files for sql server reporting services ?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
How to modify the underlying query of an existing view?
How to connect php with different port numbers?
How are the exceptions handled in sql server programming?
What is Extended user-defined?
What is coalesce and check constraint in sql server?