I have this procedure:
我有这个程序:
create proc insertfactors_pf
(
@FactorID int,
@CustomersID int,
@Number int,
@TotalPrice decimal(18, 0),
@PaidPrice decimal(18, 0),
@Date Date,
@ProductID int,
@QTY int
)
AS
BEGIN TRANSACTION
SET IDENTITY_INSERT facetors on
INSERT INTO Factor VALUES (@FactorID, @CustomersID, @Number, @TotalPrice, @PaidPrice,@Date)
SET IDENTITY_INSERT factors off
IF @@ERROR <> 0
BEGIN
ROLLBACK
RETURN
END
SET IDENTITY_INSERT Product_Factor on
INSERT INTO Produc_Factor values(@FactorID,@ProductID,@QTY)
SET IDENTITY_INSERT Product_Factor off
IF @@ERROR <> 0
BEGIN
ROLLBACK
RETURN
END
COMMIT
create proc