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

7 Answers
19591 Views
IBM, I also Faced
E-Mail Answers

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is table join?

1124

How to transfer a table from one schema to another?

1003

What is SQL Azure Fabric?

110

How to encrypt Strored Procedure in SQL SERVER?

1172

What are the basic functions for master, msdb, model, tempdb and resource databases?

991

What are the different types of join?

1173

what is an index? : Sql server database administration

987

Define full outer join in sql server joins?

998

What is difference between delete & truncate commands?

1085

what stored procedure would you use to view lock information? : Sql server administration

976

let's assume you have data that resides on sql server 6.5. You have to move it sql server 7.0. How are you going to do it? : Sql server database administration

956

Working with TLogs

1837

what are acid properties? : Sql server database administration

1002

How to count duplicated values in a column in ms sql server?

1095

Difference between LEN() and DATALENGTH() in sql server ?

1111