:: (Scope Resolution) (Transact-SQL)
APPLIES TO: SQL Server Azure SQL Database Azure Synapse Analytics Parallel Data Warehouse
The scope resolution operator :: provides access to static members of a compound data type. A compound data type is one that contains multiple simple data types and methods. Compound data types include the built-in CLR types and custom SQLCLR User-Defined Types (UDTs).
The following example shows how to use the scope resolution operator to access the
GetRoot() member of the
DECLARE @hid hierarchyid; SELECT @hid = hierarchyid::GetRoot(); PRINT @hid.ToString();
Here is the result set.