User Defined Functions: Possible to include comments in parameter intellisense?

  • If you use the LEFT() function for example it provides intellisense support for some of the required parameters.

    Is there a way to get that same descriptive help text in user defined functions?

    Some comment block you define when creating the function?

  • Maxer (8/22/2014)


    If you use the LEFT() function for example it provides intellisense support for some of the required parameters.

    Is there a way to get that same descriptive help text in user defined functions?

    Some comment block you define when creating the function?

    Quick thought, look into extended properties.

    😎

  • Red Gate SQL Prompt will do that.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • Grant Fritchey (8/22/2014)


    Red Gate SQL Prompt will do that.

    "that" being a) writing the function b) write the comments c) populate the extended properties d) all of the above (turbo version):-D

    😎

  • That is what I'm after.

    What is the proper name of that feature so I can properly Google it?

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply