저장프로시져 IF .. ELSE 사용예

CREATE PROCEDURE   USP_IFELSE
      @userName  NVARCHAR(10)
AS
        DECLARE @bYear   INT
        SELECT @bYear = birthyear FROM USETBL
          WHERE NAME = @useName;

 

        IF ( @bYear >= 1980 )
            BEGIN
                   //..............
            END
        ELSE
            BEGIN

                   //...................
            END