Call stored proc in stored proc with input and output param

[Kumarlalit]

Hi ,

I have query on Stored proc

As

I am writing a stored proc in which another sp is running , so my query is

Create Proc  Sp_firstSP
AS
Begin 
SET NOCOUNT ON 


firstparameter1 varchar(20 ) , 
secondparameter int , 
thirdparameter varchar(20) 

BEGIN 
IF ( status = 1 )
  execute secondproc @inparam1 @inparam2 
                     @outParam1   @outParam2 
  update tablename1 set column1 =  @outParam1    , column2 = @outParam2 
             where condition 
END

-- now here my query is how can i get the outparam in my firtsp so that it will become the input of the firstsp

How can i write the stored proc for use in my current application

[Rabbit]

I have no idea what this means:

how can i get the outparam in my firtsp so that it will become the input of the firstsp

Your first stored proc has no out params.

I have no idea what this means either:

How can i write the stored proc for use in my current application

What application? What is it written in? VB.NET? C++? C? Java?

[Kumarlalit]

it is in sql dear , u now sql server

[Rabbit]

You don't create applications in SQL Server. You must just mean T-SQL scripts.

You didn't answer my first question.

[ck9663]

I think Kumarlalit knows how to create basic SP that does not have parameter. You can define input and output parameter for stored procedure. Depending on how you need it, you might need to create it as a function instead.

Check Books Online on the full syntax of creating SP.

Happy Coding!!!


~~ CK

[Frinavale]

Check out this MSDN article about Using a Stored Procedure with Output Parameters.

-Frinny