saved execution plan with a IF in the stored Proc

• dubem1-878067

  Ten Centuries

  Points: 1044

  More actions

  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

• Phil Parkin

  SSC Guru

  Points: 246995

  More actions

  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

  You can lead a horse to water, but a pencil must be lead.
  Stan Laurel