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

How to update values in a table with update statements in ms sql server?

964

what is package and it uses and how can u call a package

1962

what types of replication are supported in sql server? : Sql server database administration

968

Explain different types of index?

994

What is Lock table in SQL?

1414

What is a join in sql?

1032

Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?

899

What is correlated subquery in sql server?

1023

what are constraints? : Sql server database administration

992

What according to you is the difference between mysql and sql server performance?

1026

Mention the 3 ways to get a count of the number of records in a table.

931

How to delete a login name in ms sql server?

1012

List out the different types of locks available in sql server?

940

What are the features of Embedded SQL

1081

Can you explain powershell included in sql server 2008?

898