LIN-Q

Cual es la sintaxis SQL de este LIN-Q

select @totalRowCount = count(*) from GetNames_1
select

FirstName,

LastName,

RowNumber

from

( select

fn.[FirstName] as FirstName,

fn.[LastName] as LastName,

row_number() over( order by FirstName ) as RowNumber

from

GetNames_1 fn

) as data

where

RowNumber between ( @lastRow + 1 ) and ( @lastRow + @pageSize )





__________ Information from ESET NOD32 Antivirus, version of virus signature database 5085 (20100504) __________

The message was checked by ESET NOD32 Antivirus.

http://www.eset.com