Interviews - C# Corner

Divya Parashar
how can we call the one store procedure with in the anoyher store procedure
By Divya Parashar in SQL Server on Dec 13 2006
  • ThamizhJain
    Aug, 2008 30

    An Easy example: CREATE PROCEDURE prcCallprc ( Exec prcCalledPrc ) Go EXEC prcCallprc

    • 0
  • canuja
    Dec, 2006 16

    'This stored procedure is called by a business component or webpage 
    'passing into two parameters, executes sp_ChildStoredProc and passes on value. 
    '
    The @Id OUTPUT returns the value.  

    CREATE PROCEDURE sp_ParentStoredProc
    (
    @
    col1 varchar(20)
    @
    ValuePassed varchar(50),
    )
    AS

    declare @
    Id int
    EXEC sp_ReturnValue 
    @ValuePassed, @Id OUTPUT

    INSERT INTO SomeTable
    (col1col2)
    VALUES
    (@col1, @Id)
    RETURN
    GO 

    • 0

Most Popular Companies

Most Popular Job Functions

MOST LIKED QUESTIONS