title: how to pass parameter that I get from one Stored Procedure to another Stored Procedure?
body: <p>I need to execute stored procedure that his ID will be the execute of another stored procedure. how can I do this?</p>
  
  <pre><code>ALTER PROCEDURE [dbo].[spABC]       
         @ID INT
        ,@TypeString nvarchar(50)
  
  AS 
  BEGIN 
      --exec SECOND_SP
  
      INSERT INTO dbo.abc (Id, TypeString)  
      VALUES (@"result from the second sp.", @TypeString)
  END    
  </code></pre>