MS SQL XML - Recursive Tables in Yukon

Author

Recursive Tables in Yukon

Jonathan Aneja

2005-07-19, 1:23 pm

Hi,

Does anybody have any information on the support that Yukon will have for
Recursive Tables?

Thanks,
--
Jonathan Aneja

Rainabba

2005-07-19, 8:24 pm

Yukon is still a relational DB so it doesn't technically support recursion,
although you can affect it just like in SQL2000 using a relationship where
a table refers to itself (using an ID field and a 2nd field that refers to
the ID field either it's own, or another rows). I use this model and SQLXML
Schema with max-depth specifed to retrieve recursive data in a hierarchial
manner. It's not very straight-forward, but it's definately possible.

The exception to all this is if you store XML as type XML, that data can be
recursive in itself.
If you want more info on my approach email me
REMOVErainabba@THISh
otmail.TEXTcom

"Jonathan Aneja" <v-janeja@community.nospam> wrote in message
news:7D0F8824-BC72-4D44-A3FC- 8325D062C99B@microso
ft.com...
> Hi,
>
> Does anybody have any information on the support that Yukon will have for
> Recursive Tables?
>
> Thanks,
> --
> Jonathan Aneja

Sophie Guo [MSFT]

2005-07-20, 3:24 am

Hello,

For questions of SQL server 2005, please post at the following newsgroup:

Welcome to the Microsoft SQL Server 2005 Community Technology (CTP)
Newsgroups
<http://communities.microsoft.com/ne...sqlserver2005&s
lcid=us>

Thanks for cooperation.

Sophie Guo
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security

====================
====================
=============
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
====================
====================
=============
This posting is provided "AS IS" with no warranties, and confers no rights.

Tim Anderson

2005-07-20, 8:24 pm

"Rainabba" <rainabba@ureach.com> wrote in message
news:OVjM0gKjFHA.3568@tk2msftngp13.phx.gbl...

> The exception to all this is if you store XML as type XML, that data can
> be
> recursive in itself.

There's a bit more info on using XML in this interview with Dr Michael Rys,
XML Program Manager for SQL Server 2005:

http://www.itwriting.com/sqlxml.php

Tim

Sponsored Links