?? selling.txt
字號:
CREATE PROCEDURE selling @ID varchar(40),@yaopin_id varchar(40),
@price smallmoney ,@zhekou real, @sellprice smallmoney,@unit varchar(10), @num smallint
AS
DECLARE @cost smallmoney
DECLARE @N smallint
select @cost=cost from yaopin_cost where id=@yaopin_id
select @N=switch FROM yaopin_unit WHERE id=@yaopin_id AND unit=@unit
insert into sell_list values (@id,@yaopin_id,@cost*@N,@price,@zhekou,@sellprice,@unit,@num*@N)
update yaopin_num set num=num-@num*@N where id=@yaopin_id
GO
?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -