title: sql Fetch records from sql server database table in parts
body: <p>I want to fetch records from a table in my sql server database in parts. Like, in one query I want to see first 1000 records, in next query next 1000 records. Likewise..</p>
  
  <p>Is it possible with sql server ? I am using sql server 2008. While googling, I found <code>LIMIT</code> clause for <code>mysql</code>, but it does not work for <code>sql server</code>. So can any one give in Sql. Please help.</p>