Skip to content

Limit with MSSQL

  1. DECLARE @Start datetime,
  2.  @End datetime
  3. SELECT @Start = 11,
  4.  @End = 20
  5. SELECT objName, CrDate
  6. FROM     (SELECT  ROW_NUMBER() OVER (ORDER BY name)
  7.              AS Row, convert(varchar(30), name) AS objName, crDate FROM sysobjects)
  8.             AS DatabaseObjects
  9. WHERE  Row >= @Start AND Row <= @End