updateback.txt

来自「< 飞鸿商品>>零售是基于VB+SQL2000开的商品零售管理」· 文本 代码 · 共 7 行

CREATE PROCEDURE updateback @id varchar(40), @date varchar(40), @time varchar(20), @yuan smallmoney,
	 @backcash smallmoney, @xiancash smallmoney, @username varchar(20)
AS
INSERT INTO back_index VALUES (@id,@date,@time,@yuan,@backcash,@xiancash,@username)
UPDATE sell_list SET sellprice=sellprice - @backcash,price=@xiancash WHERE id=@id
GO