Built-in user-defined functions

• kkeeffe

  SSC Eights!

  Points: 989

  More actions

  December 18, 2003 at 8:58 am

  #83987

  Per BOL, Microsoft® SQL Server™ 2000 supports two types of functions: built-in functions and user-defined functions.

  Now I find "built-in user-defined functions" (see FN_LISTEXTENDEDPROPERTY). Isn't the term "built-in user-defined funtion" a contradiction in terms, or am I missing something?

  Thanks

  k2

• jxflagg

  Hall of Fame

  Points: 3817

  More actions

  December 18, 2003 at 9:09 am

  #486975

  Perhaps a better discription would have been Microsoft UDFs? Or standard UDFs?

  UDFs are written with T-SQL and have some hard restrictions. I don't believe that built-in functions are written in T-SQL.