home
Software
Downloads
Store
Blog
Support
About
rss
twitter
facebook
Support \ LightSpeed Think Tank \ Auto detect if input params to a stored proc have a default of null set so they can be marked as Is Nullable

Auto detect if input params to a stored proc have a default of null set so they can be marked as Is Nullable

4
Voted

In the following example you will see that clientId and portalId are not required IE are nullable. UserId is required

CREATE PROCEDURE [dbo].[Name] @clientID INT=NULL, @portalID INT=NULL, @userID INT, ....

The goal would be to not have to set these by hand in the designer.

Status: New