SQL Server Performance

How to list all system functions

Discussion in 'General Developer Questions' started by kokyan, Aug 12, 2003.

  1. kokyan New Member

    I have a problem to show all system functions(e.g. SUBSTRING, GETDATE, UPPER) that available in MSSQL Server. I need the list for showing at the web page - enable user to choose which one he/she want to use.

    I believe MSSQL Server must have 1 or more store procedures or system tables that stored the system functions.

    Please help me. Thanks in advance

    HELP Wanted!
    kokyan, Aug 12, 2003
    #2

  2. Twan New Member

    I don't think that there are any procedures or functions that give you this information... Most of these are just built in as part of the SQL syntax...

    Getting them out of the BOL help files may be your best bet...

    Cheers
    Twan
    Twan, Aug 13, 2003
    #2

  3. satya Moderator

    True, no easy help other than querying agianst SYSOBJECTS which is discouraged to do so.
    Refer to Books online for system functions topic.

    HTH

    _________
    Satya SKJ
    Moderator
    SQL-Server-Performance.Com
    satya, Aug 13, 2003
    #2

  4. vbkenya New Member

    Even the system databases' sysobjects tables would only provide sytem UDFs rather than in-built functions.

    The BOL page that you might want to partially copy and paste onto your web page is "Deterministic and Nondeterministic Functions".

    Nathan H.O.
    Moderator
    SQL-Server-Performance.com
    vbkenya, Aug 13, 2003
    #2

Share This Page