SqlHierarchyId 結構

The SqlHierarchyId type represents a position in a hierarchical structure, specifying depth and breadth.

命名空間：  Microsoft.SqlServer.Types
組件：  Microsoft.SqlServer.Types (在 Microsoft.SqlServer.Types.dll 中)

語法

'宣告
<CLSCompliantAttribute(True)> _
<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered := True,  _
    MaxByteSize := , Name := "SqlHierarchyId")> _
Public Structure SqlHierarchyId _
    Implements IBinarySerialize, INullable, IComparable
'用途
Dim instance As SqlHierarchyId

[CLSCompliantAttribute(true)]
[SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = true, 
    MaxByteSize = , Name = "SqlHierarchyId")]
public struct SqlHierarchyId : IBinarySerialize, 
    INullable, IComparable

[CLSCompliantAttribute(true)]
[SqlUserDefinedTypeAttribute(Format::UserDefined, IsByteOrdered = true, 
    MaxByteSize = , Name = L"SqlHierarchyId")]
public value class SqlHierarchyId : IBinarySerialize, 
    INullable, IComparable

[<SealedAttribute>]
[<CLSCompliantAttribute(true)>]
[<SqlUserDefinedTypeAttribute(Format.UserDefined, IsByteOrdered = true, 
    MaxByteSize = , Name = "SqlHierarchyId")>]
type SqlHierarchyId =  
    struct 
        interface IBinarySerialize 
        interface INullable 
        interface IComparable 
    end

JScript 支援結構的使用，但不支援結構的宣告。

SqlHierarchyId 型別公開下列成員。

屬性

	名稱	說明
	IsNull	Gets a value indicating whether the SqlHierarchyId is nullnull 參考 (在 Visual Basic 中為 Nothing).
	Null	Gets a SqlHierarchyId with a hierarchy identification of nullnull 參考 (在 Visual Basic 中為 Nothing).

上層

方法

	名稱	說明
	CompareTo(Object)	Returns a value indicating the results of a comparison between a SqlHierarchyId and an object.
	CompareTo(SqlHierarchyId)	Returns a value indicating the results of a comparison between two SqlHierarchyId nodes.
	Equals	Evaluates whether SqlHierarchyId and obj are equal. (覆寫 ValueType.Equals(Object)。)
	GetAncestor	Retrieves the SqlHierarchyId node n levels up the hierarchical tree.
	GetDescendant	Gets the value of a descendant SqlHierarchyId node that is greater than child1 and less than child2.
	GetHashCode	Gets a hash of the path from the root node of the hierarchy tree to the SqlHierarchyId node. (覆寫 ValueType.GetHashCode()。)
	GetLevel	Gets a value indicating the level of the SqlHierarchyId node in the hierarchical tree.
	GetReparentedValue	Gets a value representing the location of a new SqlHierarchyId node that has a path from newRoot equal to the path from oldRoot to this, effectively moving this to the new location.
	GetRoot	Gets a value representing the root SqlHierarchyId node of the hierarchy.
	GetType	(繼承自 Object。)
	IsDescendantOf	Gets a value indicating whether the SqlHierarchyId node is the descendant of the parent.
	Parse	Converts the canonical string representation of a SqlHierarchyId node to a SqlHierarchyId value.
	Read	Reads from a specified binary reader into a SqlHierarchyId.
	ToString	Returns the canonical string representation of a SqlHierarchyId node from a SqlHierarchyId value. (覆寫 ValueType.ToString()。)
	Write	Writes a SqlHierarchyId to a specified binary writer.

上層

運算子

	名稱	說明
	Equality	Evaluates whether two SqlHierarchyId nodes are equal.
	GreaterThan	Evaluates whether one specified SqlHierarchyId node is greater than another.
	GreaterThanOrEqual	Evaluates whether one specified SqlHierarchyId node is greater than or equal to another.
	Inequality	Evaluates whether two SqlHierarchyId nodes are unequal.
	LessThan	Evaluates whether one specified SqlHierarchyId node is less than another.
	LessThanOrEqual	Evaluates whether one specified SqlHierarchyId node is less than or equal to another.

上層

備註

This type provides the following benefits for storing hierarchical information:

• Very compact data storage.

• Depth-first comparison. Indexes on this type are in depth-first order, and nodes close to each other in a depth-first traversal are stored near each other.

• Support for arbitrary insertions and deletions.

• A limitation of this type is that a single instance of the hierarchy data type can be no larger than 892 bytes. Hierarchies that possess too many levels to fit within this limitation must use a different data type.

The HierarchyId type is available to CLR clients as the SqlHierarchyId data type.

範例

DECLARE @employee hierarchyid
SELECT @employee = OrgNode FROM HumanResources.EmployeeDemo
  WHERE LoginID = 'adventure-works\dylan0'

SELECT * FROM HumanResources.EmployeeDemo
WHERE @employee.IsDescendantOf(OrgNode) = 1

執行緒安全性

這個型別的任何公用 static (在 Visual Basic 中為 Shared) 成員都是執行緒安全的。並不是所有的執行個體成員都保證可以用於所有的執行緒。

請參閱

參考

Microsoft.SqlServer.Types 命名空間