Get system funtions list

• BJ-594656

  Old Hand

  Points: 339

  More actions

  January 21, 2009 at 1:50 am

  #383772

  Hello,

  I have requirement to get all the system function list like aggregate function,mathematical functions etc. which are supported by SQL Server 2005.

  Please anyone help me to write function or stored procedure to get all system functions.

  Regards,

  BJ.

• NitinPatel31

  Hall of Fame

  Points: 3721

  More actions

  January 21, 2009 at 2:08 am

  #930164

  See SQL server books Online

  http://msdn.microsoft.com/en-us/library/bb431895.aspx

  Regards,
  Nitin

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  January 21, 2009 at 7:50 am

  #930347

  select * from sys.system_objects

  where type_desc like '%func%'

  MJ