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 many databases instances are there in sql server 2000?
How to loop through returning rows?
Does order by actually change the order of the data in the tables or does it just change the output?
What is sql server profiler trace data file?
What is the purpose of optimization?
what is a self join? Explain it with an example? : Sql server database administration
what purpose does the model database serve? : Sql server database administration
what is hash nonclustered index
How to select true false based on column value in sql server?
How do I setup a local sql server database?
What is xml datatype?
How do I edit a stored procedure in sql server?
How does normalization work?
What is @@rowcount in sql?
Can we make the the chages By Using the Sql if u know any function or process please inform me Actuall result: BRK1 Break 1 Part 1 00:01:00:00 60 BRK1 Break 1 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 BRK2 Break 2 Part 2 00:01:00:00 60 BRK2 Break 2 Part 3 00:01:00:00 60 BRK3 Break 3 Part 1 00:01:00:00 60 BRK3 Break 3 Part 2 00:01:00:00 60 Desired O/P: BRK1 Break 1 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 BRK2 Break 2 Part 1 00:01:00:00 60 Part 2 00:01:00:00 60 Part 3 00:01:00:00 60