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