Export (0) Print
Expand All

Invoking Built-in User-Defined Functions

SQL Server 2000

Invoking Built-in User-Defined Functions

Microsoft® SQL Server™ 2000 implements several built-in functions as user-defined functions that return a table. The invocation of these built-in user-defined functions follows special rules:

  • For built-in user-defined functions that return a table, the function name must be specified with a leading double colon (::) to distinguish it from user-defined functions that are not built-in. It also must be specified as a one-part name with no database or owner qualifications. For example:
    SELECT *
    FROM ::fn_helpcollations()
    
  • For built-in user-defined functions that return a scalar value, the function name must be specified as a one-part name (do not specify database or owner). Do not specify a leading double colon (::).

Show:
© 2014 Microsoft