If I type in "EXEC ", the candidate list pops up with a list of stored procs. Good. But now if I select one and type space, no candidate list pops up. I expect to see a list of the available parameters to the stored procedure at this point, so that I can start filling them in.
Beyond that: CTRL-SPACE brings up the list, but when I select one it doesn't help me quite as much as it could. A few things would be nice here:
A) Why not automatically fill in an "="? And if it's an OUTPUT param, give me an OUTPUT, automatically.
Even better, prepopulate it using a QA/SSMS macro, and fill in the default value if there is one... for instance, if the param were @Param, typed as int and with a default of 0, it would be cool if SQLPrompt automatically filled in:
@Param = <@Param, int, 0>
Beyond that: CTRL-SPACE brings up the list, but when I select one it doesn't help me quite as much as it could. A few things would be nice here:
A) Why not automatically fill in an "="? And if it's an OUTPUT param, give me an OUTPUT, automatically.
@Param = <@Param, int, 0>