Row_number() works on SQL 2005 and upper version, if u r trying it on 200

how to get the rowid/rownumbes of a table in sqlserver

Question Posted / renu

Answer Posted / renu

Row_number() works on SQL 2005 and upper version, if u r
trying it on 2000 it will not work.

Is This Answer Correct ?

8 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the advantages of mirroring?

934

What is enhanced database mirroring in sql server 2008?

911

How to insert multiple rows with one insert statement in ms sql server?

1052

What is trigger explain with program?

928

What is order of B+tree?

1058

What is dknf in normalization form?

979

When do you think a developer should use sql server-based cursors?

975

what is memory-optimized nonclustered indexes

956

What does <> symbol mean?

918

List the different normalization forms?

923

How can I create a report based on a query? : sql server management studio

967

What is the query and subquery?

1025

How do I find sql server instance name?

913

What happens to a trigger with multiple affected rows?

864

How to count rows with the count(*) function in ms sql server?

949