＋设为首页 ＋添加到收藏夹
create procedure ex_add_importinfo
@import_date datetime, @pri_id char(20), @improt_amount int, @discount float, @cash_or_check char(1),
@total_prices money = select price from bookinfo where pri_id=@pri_id * @improt_amount * @discount
as
insert importinfo (import_date,pri_id,improt_amount,discount,total_prices,cash_or_check) values(@import_date,@pri_id,@improt_amount,@discount,@total_prices,@cash_or_check)
提示我的错误是‘*’，和total_prices变量出错。
total_prices是一个总计。他等于单价select price from bookinfo where pri_id=@pri_id 乘以improt_amount 乘以discount折扣。
try:
create procedure ex_add_importinfo
@import_date datetime, @pri_id char(20), @improt_amount int, @discount float, @cash_or_check char(1),
@total_prices numeric(9) output
as
select @total_prices=price*@improt_amount*@discount from bookinfo where pri_id=@pri_id
insert importinfo (import_date,pri_id,improt_amount,discount,total_prices,cash_or_check) values(@import_date,@pri_id,@improt_amount,@discount,@total_prices,@cash_or_check)
