可以这样试一试:
建立一张和表A结构一样的临时表,
SELECT * INTO #TEMP
FROM 表A
WHERE 1=2
然后建立表A的触发器
Create Trigger check_delup
on 表A
after Insert,delete
as
BEGIN
--删除时
IF exists(select Count(*) from deleted)
BEGIN
TRUNCATE TABLE #TEMP
INSERT INTO #TEMP
SELECT * FROM DELETED
UPDATE #TEMP
SET C = 0
END
--插入时
IF exists(select Count(*) from inserted)
BEGIN
UPDATE 表A
SET C =1
FROM #TEMP,INSERTED INS
WHERE #TEMP.B <> INS.B
END