MAXRECURSION in SQL Server

We use MAXRECURSION statement in SQL to write recursive query.

DECLARE @TranID INT
SET @TranID = 1

;WITH CTE AS
(
        SELECT @TranID AS 'TID'
        UNION ALL
        SELECT TID+1 FROM CTE WHERE TID+1 <=1000
)
SELECT RIGHT('000000'+CAST(TID AS VARCHAR(10)),6) AS 'TranID' FROM CTE
OPTION (MAXRECURSION 1000)

That’s It.
Enjoy Learning.