CREATE TRIGGER trig_updatemkname ON [dbo].[pdtable] FOR INSERT, UPDATE, DELETE AS UPDATE A SET A.etname = i.etname FROM pdtable A, inserted i WHERE A.username = i.username
CREATE TRIGGER trig_updatemkname ON [dbo].[pdtable] FOR INSERT, UPDATE AS UPDATE pdtable SET etname = t.etname FROM pdtable A, inserted t WHERE A.username = t.username
--我猜楼主的意思是不是当更新pdtable表时更新store表的etname啊? --如果是,则: CREATE TRIGGER trig_updatemkname ON [dbo].[pdtable] FOR INSERT, UPDATE AS UPDATE store SET etname = t.etname FROM store A, inserted t WHERE A.username = t.username--对于delete,如果当删除pdtable表相关数据,你也要删除store表相关数据,则再新增触发器: CREATE TRIGGER trig_updatemkname ON [dbo].[pdtable] FOR DELETE AS DELETE FROM store A, deleted t WHERE A.username = t.username
FOR INSERT, UPDATE, DELETE
AS
UPDATE A
SET A.etname = i.etname
FROM pdtable A, inserted i
WHERE A.username = i.username
FOR INSERT, UPDATE
AS
UPDATE pdtable
SET etname = t.etname
FROM pdtable A, inserted t
WHERE A.username = t.username
你应该更新其它表才对啊,怎么会更新pdtable表呢?
--如果是,则:
CREATE TRIGGER trig_updatemkname ON [dbo].[pdtable]
FOR INSERT, UPDATE
AS
UPDATE store
SET etname = t.etname
FROM store A, inserted t
WHERE A.username = t.username--对于delete,如果当删除pdtable表相关数据,你也要删除store表相关数据,则再新增触发器:
CREATE TRIGGER trig_updatemkname ON [dbo].[pdtable]
FOR DELETE
AS
DELETE
FROM store A, deleted t
WHERE A.username = t.username