0 out of 1 rated this helpful - Rate this topic

Scope Resolution Operator (Transact-SQL)

SQL Server 2012

SQL Server 2008 R2
SQL Server 2008

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();

Here is the result set.

Reference

Operators (Transact-SQL)

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD