title: retrieve specific range of rows in a SQL Server table
body: <p>I have a table structure like (OrderID [uniqueidentifier], OrderDesciption [nvarchar]), I am using ADO.Net + C# + VSTS 2008 + SQL Server 2008. The table is big, and I want to let client give me two inputs, begin range index and end range index, and I will return specific rows of the table which is in the range (between begin range index and end range index).</p>
  
  <p>For example, if the client inputs to me 50, 100, and I want to return the 50th row until the 100th row.</p>
  
  <p>thanks in advance,
  George</p>