Chu

SQL 프로시저에서 if문 사용법

IF ELSE 구문을 사용해보자.

예1)

             IF(@NAME = '홍길동')

            BEGIN

                  SELECT *FROM SCHOOL WHERE Name = '홍길동'

            END

   ELSE

            BEGIN

                  SELECT *FROM SCHOOL

            END

또 다른 방법 EXISTS 를 사용해보자

예)

      IF EXISTS(SELECT *FROM SCHOOL WHERE NAME = 홍길동)

            UPDATE SCHOOL

            SET

                   NAME = '홍길동'

            WHERE NUM = 1986

      ELSE

            INSERT INTO SCHOOL VALUES('장보고')