SSMS should provide option to set empty string argument for "Execute Stored Procedure ..." dialog by BetterToday

Currently, when trying to execute a stored procedure using the SSMS stored procedure contect menu item "Execute Stored Procedure ..." it's not possible to provide an empty string as an argument.

If the user leaves a parameter field blank, that parameter is not provided to the stored procedure using an empty string value. Instead it's not provided at all.

This behaviour is rather confusing and unexpected (see here: http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataproviders/thread/ce0b3c7f-5c52-4005-8127-920c2e75d7c2/).


Thus, I suggest to alter the Submit NULL Value column of the Execute Procedure dialog.

Instead of providing a CheckBox column it should provide a DropDownBox column from which the user may select one of the following values for each of the stored procedure's parameters:

--------------------------------
- Submit Value (default)
- Submit NULL Value
- Omit Argument
--------------------------------

The header of that column should be renamed from Submit NULL Value to something like Argument Behaviour.

Regards,
Axel Dahmen