DECLARE 
      @from INT,
      @to INT

SELECT
      @from = 1,
      @to = 100

SELECT
      'A' + REPLICATE('0', 9 - LEN(CONVERT(VARCHAR(10), N))) + CONVERT(VARCHAR(10), N)
   FROM Tally
   WHERE N BETWEEN @from AND @to

;WITH	Numbers (N) AS
		(
		SELECT	TOP (25000)
				ROW_NUMBER() OVER (ORDER BY (SELECT NULL))
		FROM	master.sys.columns
		CROSS
		JOIN	master.sys.columns C2
		)
SELECT	'A' + RIGHT((10000000000 + N), 9)
FROM	Numbers;

ROW_NUMBER() OVER (ORDER BY (SELECT NULL))

ROW_NUMBER() OVER (ORDER BY (SELECT 1))