我是存储过程,调用如下: Exec ImportFrightToCusoms '234','1','46021020', 440, 10,.1408,4,'中国'存储过程如下: CREATE PROCEDURE Dbo.ImportFrightToCusoms @StrOrderNo Varchar(25), @SerialID AS Int, @StrMaterialNo varchar(25), @Qty numeric(18,8), @PieceQty numeric(18,8), @NetWeight numeric(18,8), @ApplyNo varchar(25), @StrCountry nvarchar(50) AS SET NOCOUNT ON UPDATE AImportCustoms SET ApplyQty=isnull(ApplyQty,0)+isnull(@ApplyQty,0),PieceQty=isnull(PieceQty,0)+isnull(@PieceQty,0),NetWeight=isnull(NetWeight,0)+isnull(@Weight,0) WHERE (OrderNo=@StrOrderNo) and (ApplyNo =@ApplyNo) and ( Country = @StrCountry )
Exec ImportFrightToCusoms '234','1','46021020', 440, 10,.1408,4,'中国'存储过程如下:
CREATE PROCEDURE Dbo.ImportFrightToCusoms
@StrOrderNo Varchar(25),
@SerialID AS Int,
@StrMaterialNo varchar(25),
@Qty numeric(18,8),
@PieceQty numeric(18,8),
@NetWeight numeric(18,8),
@ApplyNo varchar(25),
@StrCountry nvarchar(50)
AS
SET NOCOUNT ON
UPDATE AImportCustoms
SET ApplyQty=isnull(ApplyQty,0)+isnull(@ApplyQty,0),PieceQty=isnull(PieceQty,0)+isnull(@PieceQty,0),NetWeight=isnull(NetWeight,0)+isnull(@Weight,0)
WHERE (OrderNo=@StrOrderNo) and (ApplyNo =@ApplyNo) and ( Country = @StrCountry )
Exec ImportFrightToCusoms '234','1','46021020', 440, 10,.1408,4,N'中国'