mssql procedure while, if sample

대충.. 이런식..

CREATE PROCEDURE [dbo].[-----]
AS
  BEGIN
    SET nocount on;
    DECLARE  @i INT    -- while에 사용할 count
    DECLARE  @total_count INT
 
    SET @i = 1
    SELECT @total_count = COUNT(* )
      FROM employee
  
    WHILE (@i <= @total_count)
      BEGIN
        -- 직원 한명을 불러온다.
        SELECT ----------
          FROM (SELECT ROW_NUMBER()
                         OVER(ORDER BY user_id ASC)           rnum,
                       user_id,
                       user_grade
                  FROM employee) emp
         WHERE emp.rnum = @i

  
        IF (@---- IS NULL
             OR @---- != @----)
          BEGIN
            UPDATE employee
               SET -----
             WHERE user_id = @-------
          END

        SET @i = @i + 1
      END
  END