SqlHierarchyId.ToString 方法 ()
从 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 override string ToString()
public:
[SqlMethodAttribute(DataAccess = DataAccessKind::None, SystemDataAccess = SystemDataAccessKind::None,
InvokeIfReceiverIsNull = false, OnNullCall = false, IsDeterministic = true,
IsPrecise = true, IsMutator = false)]
virtual String^ ToString() override
[<SqlMethodAttribute(DataAccess = DataAccessKind.None, SystemDataAccess = SystemDataAccessKind.None,
InvokeIfReceiverIsNull = false, OnNullCall = false, IsDeterministic = true,
IsPrecise = true, IsMutator = false)>]
override ToString : unit -> string
<SqlMethodAttribute(DataAccess := DataAccessKind.None, SystemDataAccess := SystemDataAccessKind.None,
InvokeIfReceiverIsNull := False, OnNullCall := False, IsDeterministic := True,
IsPrecise := True, IsMutator := False)>
Public Overrides Function ToString As String
返回值
Type: 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
请参阅
SqlHierarchyId 结构
Microsoft.SqlServer.Types 命名空间
返回页首