ALTER proc [dbo].[getInbillMoney]
@no nvarchar(200) ,
temp numeric(12,2) output
as
declare @m numeric(12,4)
SET @m=(select SUM(costMoney) from InBill where inbillNO=@no)
return 0;
@no nvarchar(200) ,
temp numeric(12,2) output
as
declare @m numeric(12,4)
SET @m=(select SUM(costMoney) from InBill where inbillNO=@no)
return 0;
@no nvarchar(200) ,
@m numeric(12,4) output
as
declare @m numeric(12,4)
SET @m=(select SUM(costMoney) from InBill where inbillNO=@no)
return 0;
@no nvarchar(200) ,
@m numeric(12,4) output
as SET @m=(select SUM(costMoney) from InBill where inbillNO=@no)
return 0; 越忙越乱