Rownum is SQL SERVER

rubina · December 2nd, 2006, 01:48 AM

I am using Sql server with php . i need help what will be there instead of rownum in sql server. rownum works in Oracle and MySql but not in SQL server . if some one know then plz share it.

bina

SriRamaKrishna · December 2nd, 2006, 02:38 AM

Sadly , there is no rownum or rowid in sql server .But there is workaround , Refer to this
Support at microsoft for ur problem

http://support.microsoft.com/default...;EN-US;q186133

joefawcett · December 2nd, 2006, 05:31 AM

If you can upgrade to SQL 2005 then you can use ROW_NUMBER().

--

Joe (Microsoft MVP - XML)

Jeff Moden · December 2nd, 2006, 10:57 AM

Rubina,

If you would post what you are actually trying to do, there are several work arounds in SQL Server 2000.

--Jeff Moden