SQL Server Performance

what is ::fn()?

Discussion in 'T-SQL Performance Tuning for Developers' started by ramkumar.mu, Aug 16, 2006.

  1. ramkumar.mu New Member

    i see some function names starting with :: (e.g. ::fn_virtualfilestats(1,1)) - what do they mean actually?

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  2. Adriaan New Member

    When the UDF returns a table, instead of a scalar value, you have to add the two colons in front of the UDF name, or in front of the owner prefix if it is mentioned.
  3. Roji. P. Thomas New Member

    quote:Originally posted by ramkumar.mu

    i see some function names starting with :: (e.g. ::fn_virtualfilestats(1,1)) - what do they mean actually?

    To call a system supplied UDF, you should use this syntax. These functions reside in the master database. ALL system supplied UDFs are table valued udfs. Scalar valued system functions are not implemented as UDFs.

    You DONT have to use the :: syntax to call a table valued UDF that you have created in your database.

    Roji. P. Thomas
    Microsoft SQL Server MVP
    http://toponewithties.blogspot.com
  4. ramkumar.mu New Member

    Hmm... interesting. Thanks Roji

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."

Share This Page