updateback.txt

< 飞鸿商品>>零售是基于VB+SQL2000开的商品零售管理系统. 开发的很好.可以一看

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