CODEWITHSUNDEEP
sqlsql-serversql-server-2012sql-grantscope-resolution
Pரதீப்
Pரதீப்

Reputation: 93754

Scope Resolution Operator in SQL SERVER

What is the significance of using Scope Resolution Operator (::) in SQL SERVER. As we all know when we are using GRANT command Scope Resolution Operator will be part of syntax.

GRANT ALTER ON Schema :: DBO TO user_name

Is there any specific meaning for it or it is used just like that.

Upvotes: 2

Views: 1127

Answers (1)

Vikrant More
Vikrant More

Reputation: 5442

refer,

http://sqlblog.com/blogs/kalen_delaney/archive/2006/09/06/186.aspx

it does not have any meaning check below query,

SELECT * FROM ::fn_trace_getinfo(default)

and if you execute without :: it still get executed.

Upvotes: 0

Related Questions