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

Status : 


Sign in
to vote
ID 772506 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 11/28/2012 4:38:44 AM
Access Restriction Public


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:

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.

Axel Dahmen
Sign in to post a comment.
Posted by Microsoft on 2/4/2013 at 2:33 PM
Hi! Axel, thanks for writing in to Microsoft.

We took a look at this feature request and triaged it against several others and unfortunately, it did not meet the bar to be fixed. While we are closing this issue as 'won't fix', we have taken note of this internally and we will try & incorporate this request when we revisit this functionality in a future release of SSMS.

Sanjay Nagamangalam, SQL Server Manageability