:: (Scope Resolution) (Transact-SQL)

THIS TOPIC APPLIES TO: yesSQL Server (starting with 2012)noAzure SQL DatabasenoAzure SQL Data Warehouse noParallel 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, such as 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 hierarchyid type.

DECLARE @hid hierarchyid;  
SELECT @hid = hierarchyid::GetRoot();  
PRINT @hid.ToString();  

Here is the result set.


See Also

Operators (Transact-SQL)