阅读背景:

无法使用Identity Column插入表中

来源:互联网 

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 



你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: