The hierarchyid data type in SQL Server 2008
In regards to the hierarchyid data type in SQL Server 2008, what is the solution if the parent node gets deleted?
Software/Hardware used:
Software/Hardware used:
ASKED:
February 24, 2009 8:52 PM
UPDATED:
February 25, 2009 12:59 AM
RELATED QUESTIONS
- Read Excel from Sql Server 2005/2008 SQLEXPRESS
- Data Mining in SQL Server 2008 R2
- How to create an XML File from typed XML data stored in Multiple Rows and is referring to same XSD
- Synchronization of Windows Server 2008 Active Directory Users from a Sql Server table
- SQL Server 2005 vs SQL Server 2008
Answer Wiki:
You should be able to add a new node is at the same level, them move all the children to be children of that parent.
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
