while.txt

来自「jsp与数据库开发的全部代码」· 文本 代码 · 共 14 行

WHILE (SELECT AVG(price) FROM titles WHERE price IS NOT NULL) < $30 BEGIN 
UPDATE titles 
SET price = price + 1 WHERE price IS NOT NULL 
SELECT MAX(price) FROM titles 
IF (SELECT MAX(price) FROM titles)> $50 
BREAK 
ELSE
CONTINUE 
END 
SELECT AVG(price) FROM titles WHERE price IS NOT NULL 
SELECT MAX(price) FROM titles WHERE price IS NOT NULL 
PRINT 'Update complete'