Scope Resolution Operator (Transact-SQL)
Applies To: SQL Server 2014, SQL Server 2016 Preview
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.
Applies to: SQL Server (SQL Server 2008 through current version).
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.