THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

:: function calling sequence deprecated

Another item that I've seen used a lot which is now deprecated is the :: function calling sequence.

If you have code like:

SELECT * FROM ::fn_virtualfilestats(2,1);

You should now instead be coding it as:

SELECT * FROM sys.fn_virtualfilestats(2,1);

Published Thursday, February 05, 2009 5:39 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



colin leversuch-roberts said:

well it sort of makes more sense .. I guess I'd already encountered this but as I can never remember how to call functions in a select I tend to go through the various options until it works!

February 5, 2009 4:16 AM

James Luetkehoelter said:

This makes sense to me if it is a truly a table-value function (like sys.dm_db_index_physical_stats), but if it is a scalar function that replaces a server "function" like @@servername, I see no sense in this. To me this muddles the concept of the original @@servername scalar system functions with the system functions like the dm views (which are sometimes table-valued functions).

February 5, 2009 8:20 AM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement