• I let SSMS generate the script to run a stored proc, and I get this:

    DECLARE @rc int

    DECLARE @DDVersion varchar(20)

    -- TODO: Set parameter values here.

    EXECUTE @rc = [cidne2110].[dbo].[spDDAddFixAll]

    @DDVersion

    GO

    I edit the code like this, then execute it:

    DECLARE @rc int

    DECLARE @DDVersion varchar(20) = '2.1.10'

    -- TODO: Set parameter values here.

    EXECUTE @rc = [cidne2110].[dbo].[spDDAddFixAll]

    @DDVersion

    GO

    This would be the same thing:

    EXECUTE dbo.spDDAddFixAll '2.1.10'

    GO