SQL Server Performance

Maxrecursion

Discussion in 'Getting Started' started by RVG, Jan 18, 2010.

  1. RVG Member

    Hi,
    Just wanted to know what is meant by max recursion function.
    Thanks & Regards,
    Ravi Varma.
  2. preethi Member

  3. Madhivanan Moderator

    [quote user="RVG"]
    Hi,
    Just wanted to know what is meant by max recursion function.
    Thanks & Regards,
    Ravi Varma.
    [/quote]
    It is used to terminate the recursion of the CTE
    OPTION (MAXRECURSION 20) means "Do the recursion for 20 times"
  4. satya Moderator

    As you got the reply, I would like to remind you about Books Online which can be used as first hand help and more information can be obtained (don't get me wrong) [:)].

Share This Page