• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 263
  • Last Modified:

SQL 2008 R2 Features


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.

Bob

0
Bob Bender
Asked:
Bob Bender
  • 2
1 Solution
 
brutaldevCommented:
Nope. Common Table Expressions (CTE) is the recursive query work-around since SQL Server 2005.
0
 
brutaldevCommented:
You can model hierarchical data in 2008 though not as supported as you might think: http://msdn.microsoft.com/en-us/magazine/cc794278.aspx

Here is a good article on using the new type: http://msdn.microsoft.com/en-us/magazine/cc794278.aspx
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now