CREATE PROCEDURE order_number
@order_number(你要加入的定单号) int, @bb(你要加入的比例) smallmoney
AS
decalre @aa smallmoney
set nocount on
select @aa=sum(比例) from order_number where order_number=@order_number
if @aa+@bb>1
return 0
else
begin
insert into order_number (order_number,比例) values (@order_number,@bb)
return 1
end
@order_number(你要加入的定单号) int, @bb(你要加入的比例) smallmoney
AS
decalre @aa smallmoney
set nocount on
select @aa=sum(比例) from order_number where order_number=@order_number
if @aa+@bb>1
return 0
else
begin
insert into order_number (order_number,比例) values (@order_number,@bb)
return 1
end
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货