sql server 2000中存储过程怎么做循环？

WHILE (SELECT AVG(price) FROM titles) <$30BEGIN   UPDATE titles      SET price = price * 2   SELECT MAX(price) FROM titles   IF (SELECT MAX(price) FROM titles) > $50      BREAK   ELSE      CONTINUEEND