THE SQL Server Blog Spot on the Web

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

The Bit Bucket (Greg Low): 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

Comments

 

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

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement