How can we help you today? How can we help you today?

Auto Insert Inline-Table Functions

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".
fdivis
0

Comments

2 comments

Sort by
  • Bart Read
    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.


    Thanks,
    Bart
    Bart Read
    0
  • PDinCA
    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...
    PDinCA
    0

Add comment

Please sign in to leave a comment.