| title | :: (Scope Resolution) (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql | |
| ms.prod_service | sql-database | |
| ms.reviewer | ||
| ms.technology | t-sql | |
| ms.topic | language-reference | |
| dev_langs |
|
|
| ms.assetid | 764d8f91-957b-4037-997b-a9b6b533c504 | |
| author | rothja | |
| ms.author | jroth |
[!INCLUDEtsql-appliesto-ss2012-xxxx-xxxx-xxx_md]
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 hierarchyid type.
DECLARE @hid hierarchyid;
SELECT @hid = hierarchyid::GetRoot();
PRINT @hid.ToString();
[!INCLUDEssResult]
/