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

Explain database normalization?

1267

What is raid? : SQL Server Architecture

1226

What is clr ddl trigger?

1034

If no size is defined while creating the database, what size will the database have?

1035

What are null values in ms sql server?

1142

What are the functions in sql server?

991

What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration

1125

What is t-sql script to take database offline – take database online.

1137

How to delete an existing row with delete statements in ms sql server?

1151

How to select some specific rows from a table in ms sql server?

1056

What are the types of subquery?

1096

What is join query?

938

What is raid and what are different types of raid levels?

1192

How do I make a resultset scrollable?

1013

What is replication with database mirroring? : sql server database administration

1149