• 2022-05-28 问题

    智慧职教: 使用游标将Product表中前两种商品的价格提高10%。请选择适当的语句填空。 DECLARE CrsP CURSOR FOR SELECT * FROM Product OPEN CrsP FETCH NEXT FROM CrsP PDATE Product SET Price=Price*1.1 WHERE CURRENT OF CrsP CLOSE CrsP DEALLOCATE CrsP

    智慧职教: 使用游标将Product表中前两种商品的价格提高10%。请选择适当的语句填空。 DECLARE CrsP CURSOR FOR SELECT * FROM Product OPEN CrsP FETCH NEXT FROM CrsP PDATE Product SET Price=Price*1.1 WHERE CURRENT OF CrsP CLOSE CrsP DEALLOCATE CrsP

  • 1