-
DECLARE @Start datetime,
-
@End datetime
-
SELECT @Start = 11,
-
@End = 20
-
SELECT objName, CrDate
-
FROM (SELECT ROW_NUMBER() OVER (ORDER BY name)
-
AS Row, convert(varchar(30), name) AS objName, crDate FROM sysobjects)
-
AS DatabaseObjects
-
WHERE Row >= @Start AND Row <= @End