开发者

What is the purpose of "::" in T-SQL

In (non-English) book on T-SQL (SQL Server 2005) I read 开发者_运维技巧about:

SELECT * FROM ::fn_helpcollations()

Though, execution of it without "::"

SELECT * FROM fn_helpcollations()

In my SQL Server 2008 R2 gives exactly the same result.

What does "::" mean in T-SQL?


From MSDN:

However, when you call SQL Server built-in functions that return a table, you must add the prefix :: to the name of the function:

SELECT * FROM ::fn_helpcollations()

Looks like you can omit the :: in SQL Server 2005 and 2008. The :: syntax will be supported for backward compatibility.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜