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

Do I need a report server to run reports in my application?

153

How to create a view using data from another view?

905

Can we use where clause in union?

1005

What are the dmvs? : sql server database administration

1005

What are logical database components? : SQL Server Architecture

962

Where are stored procedures in sql server?

1010

What is sql server transaction log file?

994

What is an execution plan?

1059

What is the difference RDBMS and Graph Database?

1006

How does using a separate hard drive for several database objects improves performance right away?

885

What is the native system stored procedure to execute a command against all databases?

970

what is raid and what are different types of raid configurations? : Sql server database administration

976

Explain sql server service broker?

929

What is dirty read?

1041

What are the requirements on sql server network connections?

898