3楼已经给你答案了。我假设a,b两个表,a:aid,aname aid为主键b:bid,bname,bdata bid为主键然后……给A表添加触发器,代码如下:CREATE TRIGGER tr_test ON a FOR INSERT,DELETEAS BEGIN SET NOCOUNT ON IF EXISTS (SELECT * FROM inserted) INSERT INTO b SELECT aname, \\\'\\\' FROM inserted ELSE DELETE FROM b WHERE EXISTS (SELECT * FROM deleted WHERE bname = aname)ENDGO测试语句:use testgoinsert into a values (\\\'n1\\\')insert into a values (\\\'n2\\\')insert into a values (\\\'n3\\\')update b set bdata = \\\'d1\\\' where bname = \\\'n1\\\'update b set bdata = \\\'d2\\\' where bname = \\\'n2\\\'update b set bdata = \\\'d3\\\' where bname = \\\'n3\\\'delete from a where aname = \\\'n1\\\'insert into a values (\\\'n4\\\')
到吾爱游戏|游戏爱好者论坛网站查看回答详情>>
|