An example of executing a sproc in MSSQL while passing in parameters.

EXECUTE My_Sproc @PriceOfTeaInChina = 13.42, @Flavor = 'Mint'

The parameters here are not OUT or INOUT parameters. They are IN parameters.