设有商品表(商品编号 商品名 进货单价 销售单价) 销售表(商品编号 销售时间 销售数量)和
问题详情
设有商品表(商品编号，商品名，进货单价，销售单价)、销售表(商品编号，销售时间，销售数量)和商品利润表(商品编号，总利润)。设进货单价、销售数量、销售单价和总利润均为整型，商品编号和商品名的类型均为varchar(20)。总利润的默认值为0。请编写完成下列功能的存储过程：根据给定的商品编号修改对应商品的总利润。(10分)请帮忙给出正确答案和分析，谢谢！
参考答案
正确答案：存储过程如下：CREATE PROCEDURE [email protected] VARCHAR(20)[email protected] [email protected] INT、[email protected] [email protected] [email protected] VARCHAR(20)[email protected]=(SELECT进货单价FROM商品表WHERE商品编号[email protected])[email protected]=(SELECT销售单价FROM商品表WHERE商品编号[email protected])[email protected]=(SELECT销售数量FROM商品表WHERE商品编号[email protected])[email protected]=(@[email protected])*@[email protected]=CONVERT([email protected])UPDATE商品利润表SET总利润[email protected]商品编号[email protected]
存储过程如下：CREATE PROCEDURE [email protected] VARCHAR(20)[email protected] [email protected] INT、[email protected] [email protected] [email protected] VARCHAR(20)[email protected]=(SELECT进货单价FROM商品表WHERE商品编号[email protected])[email protected]=(SELECT销售单价FROM商品表WHERE商品编号[email protected])[email protected]=(SELECT销售数量FROM商品表WHERE商品编号[email protected])[email protected]=(@[email protected])*@[email protected]=CONVERT(VARCHAR，@ZLRl)UPDATE商品利润表SET总利润[email protected]商品编号[email protected]
