Can any one let me know how to find rownum in sql server
thanks in advance
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?
Joseph R.P. Maloney, CSP,CDP,CCP
'The answer is 42'