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)
Syntax
'Declaration
<SqlMethodAttribute(DataAccess := DataAccessKind.None, SystemDataAccess := SystemDataAccessKind.None, _
InvokeIfReceiverIsNull := False, OnNullCall := False, _
IsDeterministic := True, IsPrecise := True, IsMutator := False)> _
Public Shared Function Parse ( _
input As SqlString _
) As SqlHierarchyId
'Usage
Dim input As SqlString
Dim returnValue As SqlHierarchyId
returnValue = SqlHierarchyId.Parse(input)
[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public static SqlHierarchyId Parse(
SqlString input
)
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public:
static SqlHierarchyId Parse(
SqlString input
)
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
static member Parse :
input:SqlString -> SqlHierarchyId
public static function Parse(
input : SqlString
) : SqlHierarchyId
Parameters
- input
Type: System.Data.SqlTypes.SqlString
String representation of SqlHierarchyId node.
Return Value
Type: Microsoft.SqlServer.Types.SqlHierarchyId
SqlHierarchyId representing the node described canonically.
Remarks
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.
Examples
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