Increment value like 001 to 999 in sql

;WITH PseudoNumbers AS
(
	SELECT 1 AS MyVal, CAST('00001' AS NVARCHAR(5)) AS PseudoNumber
	UNION ALL
	SELECT MyVal + 1 AS MyVal, CAST(LEFT('00000', LEN('00000')-LEN(CAST(MyVal+1 AS NVARCHAR(5)))) +  CAST(MyVal+1 AS NVARCHAR(5)) AS NVARCHAR(5)) AS PseudoNumber
	FROM PseudoNumbers
	WHERE MyVal <100
)
SELECT *
FROM PseudoNumbers
--OPTION (MAXRECURSION 0)
--uncomment above line, if you want to get more than 100 records ;)
--Thank you, Code-Hunt ;) for your comment

M.. PseudoNumber
1   00001
2   00002
3   00003
4   00004
5   00005
...
100 00100

SELECT RIGHT('00'+ CONVERT(VARCHAR,Id),3) FROM myTable;

DECLARE @intFlag VARCHAR(20)
 SET @intFlag =0
WHILE (@intFlag <=998)
BEGIN
SET @intFlag = @intFlag + 1
SET @intFlag='00'+@intFlag
PRINT @intFlag
END
GO