PRODUCT (产品表):ID(编号) NAME(名称) 主键ID;
RELATION (产品关联表):PID RID 主键(PID,RID)外键(PID 引用产品表 ID;RID引用产品表ID)
就是登记关联物品
现在我要删除ID=3的物品
以下是存储过程
CREATE PROCEDURE P_DELETEPRODUCT
(
@id int
)
AS
BEGIN
BEGIN TRANSACTION
DELETE [RELATION] WHERE [PID] = @id
DELETE [PRODUCTS] WHERE [ID] = @id
IF @@ERROR=0
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
END
END
怎么老是提示
DELETE 语句与 COLUMN REFERENCE 约束 'FK_Relation_Products' 冲突。该冲突发生于数据库 'XXX',表 'Relation', column 'RID'。
删除不了
RELATION (产品关联表):PID RID 主键(PID,RID)外键(PID 引用产品表 ID;RID引用产品表ID)
就是登记关联物品
现在我要删除ID=3的物品
以下是存储过程
CREATE PROCEDURE P_DELETEPRODUCT
(
@id int
)
AS
BEGIN
BEGIN TRANSACTION
DELETE [RELATION] WHERE [PID] = @id
DELETE [PRODUCTS] WHERE [ID] = @id
IF @@ERROR=0
BEGIN
COMMIT TRANSACTION
END
ELSE
BEGIN
ROLLBACK TRANSACTION
END
END
怎么老是提示
DELETE 语句与 COLUMN REFERENCE 约束 'FK_Relation_Products' 冲突。该冲突发生于数据库 'XXX',表 'Relation', column 'RID'。
删除不了
DELETE [PRODUCTS] WHERE [ID] = @id
DELETE [RELATION] WHERE [PID] = @id
DELETE [RELATION] WHERE [PID] = @id OR RID = @id
DELETE [PRODUCTS] WHERE [ID] = @id