Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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