How to store data to temp table from Stored Procedure With Output parameter?

I have a stored procedure which return result by setting multiple output parameter. I want to store those output parameter values to temp table, how can I do that?


You can create a temp table as follows:

create table #temp_table_name
    firstOutputParam int,
    secondOutputParam varchar(50), 
    thirdOutputParam varchar(150)

Since the stored procedure is executing, the temp table will remain valid until the end of the execution.

Need Your Help

Mysql Unknown column on view

php mysql

Im having a bad time trying to understand how Views, Unions and joins works,

What is the Reason large sites don't use MySQL with ASP.NET? sql mysql sql-server scalability

I have read this article from High Scalability about Stack Overflow and other large websites. Many large high traffic .NET sites such as, MySpace and Stack Overflow all use .NET