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 to create function with parameter in sql server?
Explain syntax for viewing, dropping and disabling triggers?
Suppose you want to implement the one-to-one relationships while designing tables. How would you do it?
what are the types of indexes? : Sql server database administration
How to make a column nullable?
Do you know exporting and importing utility?
Find columns used in stored procedure?
Difference between Inner vs outer joins?
What were the latest updates to SQL Azure service?
in a table is b in column k (manikanta,sivananda,muralidhar) i want result like (mnikanta,sivnanda,murlidhar) please slove it
Name and describe few console utilities for ssrs?
Explain isolation levels that sql server supports?
how can a database be repaired? : Sql server administration
What is the default value of an integer data type in sql server 2005?
List out the difference between union and union all in sql server?