Auto Insert Inline-Table Functions

fdivis

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

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

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...