SQL 2008 R2 Features

Posted on 2011-10-09
Last Modified: 2012-06-27

Simple question, may be easy points....

Does 2008 support hierarchical data WITHOUT the use of recursive queries?

I believe that 2005, it did not and recursive queries were needed.


Question by:Bob Bender
    LVL 11

    Accepted Solution

    Nope. Common Table Expressions (CTE) is the recursive query work-around since SQL Server 2005.
    LVL 11

    Expert Comment

    You can model hierarchical data in 2008 though not as supported as you might think:

    Here is a good article on using the new type:

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    This video discusses moving either the default database or any database to a new volume.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now