title: Does SQL SERVER supports FIRST_ROWS feature like oracle does?
body: <p>We known that Oracle support a optimizer mode called <strong>FIRST_ROWS</strong> ，I want known whether SQL Server has some thing like this. Meaning <code>what should I do if I want to get the first row of a select statement as soon as possible while not waiting it to complete</code>. If it has, can I use it in database drivers like ODBC and may be ADO components?</p>