SqlHierarchyId ノードの正規の文字列表記を SqlHierarchyId 値から取得します。
名前空間: Microsoft.SqlServer.Types
アセンブリ: Microsoft.SqlServer.Types (Microsoft.SqlServer.Types.dll)
構文
'宣言
<SqlMethodAttribute(DataAccess := DataAccessKind.None, SystemDataAccess := SystemDataAccessKind.None, _
InvokeIfReceiverIsNull := False, OnNullCall := False, _
IsDeterministic := True, IsPrecise := True, IsMutator := False)> _
Public Overrides Function ToString As String
'使用
Dim instance As SqlHierarchyId
Dim returnValue As String
returnValue = instance.ToString()
[SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public override string ToString()
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)]
public:
virtual String^ ToString() override
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
abstract ToString : unit -> string
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false,
IsDeterministic = true, IsPrecise = true, IsMutator = false)>]
override ToString : unit -> string
public override function ToString() : String
戻り値
型: System.String
文字列。
説明
SqlHierarchyId データ型から文字列型への変換が発生したときに暗黙的に呼び出されます。
Parse とは逆の動作をします。
使用例
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