rownum in sql server

Hi friends,
Can any one let me know how to find rownum in sql server

thanks in advance

cheese
anandkl

I think you will find that ROWNUM is a logical/derived field in Oracle not found in SQL Server.

Are you looking for an Idenity field/Primary Key?