Is there a way to have a variable in a stored procedure that is not an input variable? I just need it for use inside my stored procedure but when I set it up like this
it shows up as an input when the stored procedure is run from Management Studio. I tried this
@MyVariable varchar(50) = Null
which then allows the user to start the stored procedure without entering a value for the varible but I don't want it to show up at all. It just needs to be there for internal use only.