Méthode SqlHierarchyId.Parse

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

Espace de noms :  Microsoft.SqlServer.Types
Assembly :  Microsoft.SqlServer.Types (en Microsoft.SqlServer.Types.dll)

Syntaxe

'Déclaration
<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
'Utilisation
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

Paramètres

• input
  Type : System.Data.SqlTypes.SqlString
  String representation of SqlHierarchyId node.

Valeur de retour

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

Notes

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.

Exemples

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

Voir aussi

Référence

SqlHierarchyId Structure

Espace de noms Microsoft.SqlServer.Types