请教一个简单的触发器如何写
工人表workertable(workerid int, name varchar(20));
刷卡表cardtable(workerid int, brushtime datatime);

当删除 workertable中记录时,通过触发器删除删除card中相应记录



[解决办法]
CREATE TRIGGER tr_delete
ON [工人表]
AFTER DELETE
AS
BEGIN
DELETE FROM [刷卡表]
WHERE [刷卡表].workerid = deleted.workerid
END
[解决办法]
CREATE TRIGGER tr_delete
ON [工人表]
AFTER DELETE
AS
BEGIN
SET NOCOUNT ON --加上这句
DELETE FROM [刷卡表]
WHERE [刷卡表].workerid = deleted.workerid
END
在某些语言中(如Delphi)由于ADO的BUG，导致出现问题！