DECLARE @StringValue AS nvarchar(4000), @hierarchyidValue AS hierarchyid SET @StringValue = ‘/1/1/3/’ SET @hierarchyidValue = 0x5ADE Use hierarchyid::Parse(@stringValue) to convert string value to hierarchyid and Use @hierarchyidValue.ToString() to convert hierarchyid to String Source: http://technet.microsoft.com/en-us/library/bb677201.aspx Blog this! Bookmark on Delicious Digg this post Recommend on Facebook Share on Linkedin Share via MySpace Tweet about it Bookmark in [...]
Continue reading about Converting SQL Server HierarchyID Data Type to String
