SqlHierarchyId.ToString 메서드

SQL Server 2012

Returns the canonical string representation of a SqlHierarchyId node from a SqlHierarchyId value.

네임스페이스:  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 override string ToString()

반환 값

유형: System.String
String

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

Acts as the opposite of 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

커뮤니티 추가 항목

추가
표시: