Post reply

saved execution plan with a IF in the stored Proc

  • April 26, 2010 at 8:01 pm

    #140083

    I want to know if a stored proc with a IF within will re-execute the execution plan or use the saved execution plan?

    IF @language = 1

    SELECT NAME_L1

    FROM Table1

    ELSE

    SEECT NAME_L2

    FROM Table1

    Let say this stored proc is call 10 consecutive time with @language = 1 before a call is made with @language = 2

    Thank you

    Martin

  • April 27, 2010 at 12:02 am

    #1157987

    This forum is for questions about SSIS - you should probably post this question here.

    The absence of evidence is not evidence of absence
    - Martin Rees
    The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
    - Phil Parkin

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

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