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 populate a table in sql server?

504

How many primary keys are possible in a table?

520

What are the types of dml?

558

How to loop through result set objects using mssql_fetch_array()?

544

How many triggers are possible per table?

629

What objects does the fn_my_permissions function reports on? : sql server security

562

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

3759

You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?

243

What are “lock” hints?

593

Give the query of getting last two records from the table in SQL SERVER?

542

How to use clusters?

553

Explain the flow of creating a cube? : sql server analysis services, ssas

628

Mention the differences between substr and charindex in sql server.

525

Can a unique index be created on a column, which contains null?

523

How does SSIS(Sql Server Integration Services) deffer from DTS(Data Transformation Services)?

601