请问，存储过程中循环语句怎么写？实现for循环的功能。
请问，存储过程中循环语句怎么写？实现for循环的功能。
[解决办法]
sql
USE pubs
GO
WHILE (SELECT AVG(price) FROM titles) < $30
BEGIN
UPDATE titles
SET price = price * 2
SELECT MAX(price) FROM titles
IF (SELECT MAX(price) FROM titles) > $50
BREAK
ELSE
CONTINUE
END
PRINT 'Too much for the market to bear'
