title: Sybase system procedure - how to get result?
body: <p>Is there any way of saving the result set of a <strong>SYSTEM</strong> procedure in <strong>Sybase ASE 15</strong>?</p>
  
  <p>For example, if i want to get details about all the columns of a table, i would use the following code:<br> <code>sp_columns 'TABLE_NAME'</code>.</p>
  
  <p>I want to save the result into a temporary table or get it by using a cursor to use it for other queries. Is there any way of doing it?</p>
  
  <p>Note: I am aware i could write my query by using the system tables and get the same result, but if this is possible, i would prefer this method.</p>