![]() ![]() The average number of bits that are required to represent a node in a tree with n nodes depends on the average fanout (the average number of children of a node). Values for hierarchyid have the following properties: Key Properties of hierarchyidĪ value of the hierarchyid data type represents a position in a tree hierarchy. Use the hierarchyid functions in Transact-SQL to query and manage hierarchical data. Use hierarchyid as a data type to create tables with a hierarchical structure, or to describe the hierarchical structure of data that is stored in another location. Examples of the hierarchical data that is commonly stored in databases include the following: Hierarchical relationships exist where one item of data is the parent of another item. Hierarchical data is defined as a set of data items that are related to each other by hierarchical relationships. hierarchyid is optimized for representing trees, which are the most common type of hierarchical data. The built-in hierarchyid data type makes it easier to store and query hierarchical data. ![]() Applies to: SQL Server Azure SQL Database Azure SQL Managed Instance ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |