SQL Server Performance

Capturing output

Discussion in 'T-SQL Performance Tuning for Developers' started by Rajat, Jul 11, 2005.

  1. Rajat New Member

    <br />I want to capture the output of a Sp which returns a recordset. One way of doing it is to create a temporary table and execute the Sp with Insert. <br /><br />Create #temp1 (col1 int, col2 int)<br /><br />Insert into #temp1<br /> (col1 int, col2 int)<br />Execute &lt;SpName&gt; &lt<img src='/community/emoticons/emotion-4.gif' alt=';P' />ara1&gt;, &lt<img src='/community/emoticons/emotion-4.gif' alt=';P' />ara2&gt;<br /><br />Is there any other way of doing it?. <br />
  2. dineshasanka Moderator

    http://www.databasejournal.com/features/mssql/article.php/3386661

Share This Page