InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 13:05:39 GMT20http://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxI don't think you should take the blame for this one. I think Books Online should be more explicit.This was a great learning experience! I will now know that anything with methods must be a CLR type.):-DThu, 14 Feb 2008 09:24:54 GMTDr. Diana Deehttp://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxThere isn't a great reference out there, and apologies for not getting a better one. The HierarchyID, from what I've seen from various sources, is a binary representation of a hierarchy, and it's implemented as a CLR type. The ToString() method will return a string representation with slashes, but the type itself is essentially a UDT, that's built into the system.Thu, 14 Feb 2008 09:17:44 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic455508-462-1.aspx[quote][b]Kelsey.Thornton (2/14/2008)[/b][hr]I was reading the same article, and inferred from the fact that it "is available to CLR clients as the SqlHierarchyId data type" that the CLR data type was in fact SqlHierarchyId.The representation used in the article suggest that is is some kind of string (as it mentions slashes etc.). The fact that you convert it to nvarchar by using the ToString method made me think it must, therefore, be a varchar type...[/quote]Agree...nvarchar or varchar also due to the size of the sqlhierarchyid making it too big to be an int. The clr type is SQLhierarchyid.Thu, 14 Feb 2008 08:41:06 GMTBob Griffinhttp://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxI was reading the same article, and inferred from the fact that it "is available to CLR clients as the SqlHierarchyId data type" that the CLR data type was in fact SqlHierarchyId.The representation used in the article suggest that is is some kind of string (as it mentions slashes etc.). The fact that you convert it to nvarchar by using the ToString method made me think it must, therefore, be a varchar type...Thu, 14 Feb 2008 03:01:59 GMTKelsey Thorntonhttp://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxIn addition to providing a good summmary of the new features of sql server 2008, the following link provides a much better explanation:http://www.windowsdevpro.com/Pages/Content/1717/1717.aspxKind Regards,JenThu, 14 Feb 2008 02:59:11 GMTJen-574053http://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxDitto to what Dr Diana Dee said - I was at the same article. It feels like there is something missing here in terms of clarifying information...Wed, 13 Feb 2008 23:54:23 GMTStephanie J Brownhttp://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxI was at that very page in SQL 10 Books Online:http://msdn2.microsoft.com/en-us/library/bb677290(SQL.100).aspxAnd I quote:"The hierarchyid data type is a variable length, system data type."and"The hierarchyid type is available to CLR clients as the SqlHierarchyId data type."Does the fact that the hierarchy type has methods mean it is a CLR type? That would be the only clue I could see in that article that it is a CLR type. The article never explicitly says that.I always have trouble reading between the lines. I always need things said explicitly.):-DWed, 13 Feb 2008 22:16:04 GMTDr. Diana Deehttp://www.sqlservercentral.com/Forums/Topic455508-462-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/SQL+Server+2008/62217/">HierarchyID</A>[/B]Wed, 13 Feb 2008 22:12:31 GMTSite Owners