Post reply

Using SQL SP how to receive Multiple Output Param from another SQL SP

  • September 14, 2009 at 11:55 pm

    #138861

    First SP is used to check how many tables Referred

    and return the Referred tables names

    Second SP ,First Execute the First SP and get the O/P values

    if Referred then displays the Referred tables names, else delete the matched data from the table1

    SP1

    CREATE PROCEDURE [dbo].[Table_spCheckRef]

    @CodeNVARCHAR(50),

    @COUNT BIGINT = NULL OUTPUT,

    @STRNVARCHAR(500)= NULL OUTPUT

    AS

    SET @COUNT=(SELECT COUNT(*) FROM Table1 WHERE Code=@Code)

    IF @COUNT > 0

    SET @STR='table value Referred the following table1,table2 '

    ELSE

    SET @STR=null

    SP2

    CREATE PROCEDURE [dbo].[Table_spdelete]

    @CodeNVARCHAR(50)

    AS

    DECLARE @COUNT BIGINT,@STR NVARCHAR(500);

    EXEC test_sp @Code, @COUNT OUTPUT, @STR OUTPUT

    IF @COUNT= 0

    BEGIN

    DELETE FROM Table1 WHERE Code=@Code

    PRINT 'Data deleted...'

    END

    ELSE

    BEGIN

    PRINT LTRIM(@STR)

    END

    But i cant get the exact values...

    how to solve this problem help me please

  • September 15, 2009 at 12:49 am

    #1053595

    Not sure if I understood your requirement properly but if its about the execution then I am sure you would have looked at the stored procedure being referred to in the second SP (test_sp) which is not the one that you are creating.

    ---------------------------------------------------------------------------------

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply