If Then or Case statement

• MJ-727860

  SSC Veteran

  Points: 252

  More actions

  August 31, 2008 at 11:47 am

  #382468

  Is it possible to run more than one sql statement given a condition ie:

  if(1 = 1)

  --insert statement

  --update statement

  --etc

  else

  --insert statement

  --update statement

  --etc

  :crazy:

• Ken Simmons

  SSCertifiable

  Points: 7822

  More actions

  August 31, 2008 at 11:52 am

  #865508

  Yes. You need a Begin/End when using multiple statements.

  IF (1=1)

  Begin

  insert...

  update...

  END

  ELSE

  Begin

  insert...

  update...

  END

• MJ-727860

  SSC Veteran

  Points: 252

  More actions

  August 31, 2008 at 12:01 pm

  #865509

  Thank you! 😀