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?

Answers


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?

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 plentyoffish.com, MySpace and Stack Overflow all use .NET