Control the behaviour of SQL Prompt insertion
I would like the ability to control how SQL Prompt completes my statements for me, this mostly becomes an issue with procedures with multiple optional parameters.
If I used sp_whoisactive as an example, there are multiple optional parameters but it is capable of running with no parameters at all, so I find myself having to spend longer than I want to either highlighting the bit I want execute or deleting all the parameters that just got written for me.
So a setting where I can assign keys to complete full statement and keys to simply complete object name would be really useful.
As as a basic example, I type "EXEC spw" I hit TAB if want the statement completed, I hit ENTER if I want the statement plus all optional parameters. You could have similar behaviour for INSERT statements etc...
Note, whilst I realise you could achieve this with a snippet for a single parameter, this more about the ability to do it on demand for all and any object.
![](https://secure.gravatar.com/avatar/c78c49d70ac990cb42325412eee933f2?size=40&default=https%3A%2F%2Fassets.uvcdn.com%2Fpkg%2Fadmin%2Ficons%2Fuser_70-6bcf9e08938533adb9bac95c3e487cb2a6d4a32f890ca6fdc82e3072e0ea0368.png)