LIMIT in mssql

[Anon]

Hi,

does anyone know how to use mssql_fetch_batch()function?

Or does anyone know how to do something limk MySQL "Select * from........ LIMIT 0,1"?? How to do it in MSSQL?

Thanks
Louis

[Anon]

The closest thing I know of in MSSQL is:

SET ROWCOUNT 1

[Anon]

Try
SELECT top 100 FROM table ...