Export (0) Print
Expand All

SqlHierarchyId.Parse Method

Converts the canonical string representation of a SqlHierarchyId node to a SqlHierarchyId value.

Namespace:  Microsoft.SqlServer.Types
Assembly:  Microsoft.SqlServer.Types (in Microsoft.SqlServer.Types.dll)

[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None, 
	InvokeIfReceiverIsNull = false, OnNullCall = false, 
	IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public static SqlHierarchyId Parse(
	SqlString input
)

Parameters

input
Type: SqlString
String representation of SqlHierarchyId node.

Return Value

Type: Microsoft.SqlServer.Types.SqlHierarchyId
SqlHierarchyId representing the node described canonically.

Called implicitly when a conversion from a string type to SqlHierarchyId data type occurs.

Acts as the opposite of ToString.

An exception is raised if Parsereceives a value that is not a valid string representation of a SqlHierarchyId.

This member is static.

DECLARE @StringValue AS nvarchar(4000), @hierarchyidValue AS hierarchyid
SET @StringValue = '/1/1/3/'
SET @hierarchyidValue = 0x5ADE

SELECT hierarchyid::Parse(@StringValue) AS hierarchyidRepresentation,
 @hierarchyidValue.ToString() AS StringRepresentation ;
GO

Community Additions

ADD
Show:
© 2015 Microsoft