CREATE TRIGGER [dbo].[tg_teac_id] ON [dbo].[A] after UPDATE AS BEGIN DECLARE @OLD_TEAC_ID INT DECLARE @NEW_TEAC_ID INT SELECT @OLD_TEAC_ID=TEAC_ID FROM DELETED SELECT @NEW_TEAC_ID =TEAC_ID FROM INSERTED UPDATE B SET TEAC_ID=@NEW_TEAC_ID WHERE TEAC_ID=@OLD_TEAC_ID END
--A(teac_id,teac_name) ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (teac_id) GO --B(ID,teac_id,course_id) ALTER TABLE B ADD CONSTRAINT FK_B FOREIGN KEY (teac_id) REFERENCES A(teac_id) ON UPDATE CASCADE ON DELETE CASCADE GO
ON [dbo].[A]
after UPDATE
AS
BEGIN
DECLARE @OLD_TEAC_ID INT
DECLARE @NEW_TEAC_ID INT
SELECT @OLD_TEAC_ID=TEAC_ID FROM DELETED
SELECT @NEW_TEAC_ID =TEAC_ID FROM INSERTED
UPDATE B SET TEAC_ID=@NEW_TEAC_ID WHERE TEAC_ID=@OLD_TEAC_ID
END
ALTER TABLE A ADD CONSTRAINT PK_A PRIMARY KEY (teac_id)
GO
--B(ID,teac_id,course_id)
ALTER TABLE B ADD CONSTRAINT FK_B FOREIGN KEY (teac_id) REFERENCES A(teac_id)
ON UPDATE CASCADE
ON DELETE CASCADE
GO