| title | :: (Scope Resolution) (Transact-SQL) | Microsoft Docs | |
|---|---|---|
| ms.custom | ||
| ms.date | 03/06/2017 | |
| ms.prod | sql | |
| ms.prod_service | sql-database | |
| ms.service | ||
| ms.component | t-sql|language-elements | |
| ms.reviewer | ||
| ms.suite | sql | |
| ms.technology |
|
|
| ms.tgt_pltfrm | ||
| ms.topic | language-reference | |
| applies_to |
|
|
| dev_langs |
|
|
| ms.assetid | 764d8f91-957b-4037-997b-a9b6b533c504 | |
| caps.latest.revision | 10 | |
| author | douglaslMS | |
| ms.author | douglasl | |
| manager | craigg | |
| ms.workload | Inactive |
[!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, 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();
[!INCLUDEssResult]
/