How To Declare Input-Output Parameters In SQL Server Stored Procedure/Function? : <p>In Oracle, </p>

<p>We can declare an input-output parameters (not just input <strong>or</strong> output) like the following:</p>

<pre><code>Create Or Replace Procedure USERTEST.SimpleInOutProcedure(
    p_InputInt Int,
    p_OutputInt out Int,
    p_InputOutputInt in out Int
) AS
BEGIN
    p_OutputInt := p_InputInt + 1;
    p_InputOutputInt := p_InputOutputInt + p_InputOutputInt;
END;
</code></pre>

<p>However, as I try to declare such in SQL Server, the script would not compile:</p>

<pre><code>create procedure SimpleInOutProcedure 
    @p_InputInt int, @p_OutputInt int input output
As
Begin
    Select * from TestTableCommonA;
End
</code></pre>

<p>The word "input" is not expected, thus not blue-colored in the SQL Server Management Studio:</p>

<p><a href="https://i.stack.imgur.com/Pa4X6.png" rel="noreferrer"><img src="https://i.stack.imgur.com/Pa4X6.png" alt="enter image description here"></a></p>

<p>What's wrong with my script, how to declare input-output parameters in SQL Server Stored Procedure/Function?</p>

<p>I want to do this because I need to create "equivalent" reader for SQL Server DB which previously was created for Oracle DB and has the reader for in/out parameters.</p>
