What are the challenges you face when working across database platforms? Take the survey

Auto Insert Inline-Table Functions

fdivisfdivis Posts: 7
edited January 23, 2007 1:21PM in SQL Prompt Previous Versions
When typing SELECT * FROM udf_function SQL Prompt does not automatically insert the parameters even when having checked the "Insert Parameters for functions and stored procedures".


  • Options
    Bart ReadBart Read Posts: 997 Silver 1
    Hi there,

    That's correct. The reason we don't do it in that situation is that the EXEC style syntax where the function parameters are named explicitly is illegal in that context. We might provide an option whereby sensible defaults for each parameter are provided along with perhaps a comment indicating which parameter is being passed though in the future.

    Sorry I can't be of more direct assistance right now.

    Bart Read
    Principal Consultant
    bartread.com Ltd
  • Options
    PDinCAPDinCA Posts: 642 Silver 1
    Would you consider adding the parameters in a form whereby we can invoke MS's Ctrl+Shift+M to substitute variables or literals, please? At least we would have a guide, rather than having to find the UDF in the Object Explorer...
    Jesus Christ: Lunatic, liar or Lord?
    Decide wisely...
Sign In or Register to comment.