scope-resolution-operator-transact-sql.md

title	Scope Resolution Operator (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	03/06/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
applies_to	SQL Server (starting with 2008)
dev_langs	TSQL
ms.assetid	764d8f91-957b-4037-997b-a9b6b533c504
caps.latest.revision	10
author	BYHAM
ms.author	rickbyh
manager	jhubbard

Scope Resolution Operator (Transact-SQL)

[!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.

Examples

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]

/

See Also

Operators (Transact-SQL)