title: T-SQL Detect the type of the columns that store procedure returns
body: <p>I am not going to deep into the details but I need a way to determined the type of the return columns by store procedure.</p>
  
  <p>Is there a way to achieved that and I do not look for a solution that works with specified procedure - I should be able to detect this in other procedure that receive as parameter other procedure's name.</p>
  
  <p>I am using SQL Server 2012.</p>